Re: joining tables

2019-09-02 Thread Patrick Headley
The first thing I noticed is that there is no primary key field on Names. If Friend is a child table then you will use a LEFT OUTER JOIN. Friend will need a foreign key field that has values matching the primary key field in Names. Friend should also have it's own primary key field. If you ar

joining tables

2019-09-02 Thread TedJones
I'm having problems joining 3 tables to provide a 4th table in the correct format. I believe I need a FULL OUTER JOIN but does not give the result that I require.See below: Example 1 Table: NamesTable: Friend NameTel email PostCodeNamefrien

Re:

2019-09-02 Thread Aditya Toshniwal
Hi Thegeshwar, Kindly send it to pgsql-ad...@postgresql.org. It is the correct mailing group for PostgresSQL On Mon, Sep 2, 2019 at 5:18 PM Thegeshwar SM wrote: > Hello > > I have recently installed PostgreSQL on my system and when I use the shell > to check if it is working I get an error ,who

Re: Thegeshwar

2019-09-02 Thread Ariel Giomi
Hi! That looks more like a windows error.   You could see https://answers.microsoft.com/en-us/windows/forum/all/corrupted-recycle/4388b107-bb28-413d-8578-6defd768932b best regards Ariel El 02/09/2019 a las 7:37, Thegeshwar SM escribió: Hello I have recently installed PostgreSQL on my sys

Re: Cannot log in to pgadmin interface with Docker

2019-09-02 Thread Dave Page
Hi [please keep the mailing list CC'd] On Fri, Aug 23, 2019 at 9:46 PM Charalampos Fanoulis < charalampos.fanou...@gmail.com> wrote: > Hey, thanks for the answers. No, it was just that single instance (it's in > server mode), and was using the default credentials as shown on the docker > image p