Postgres Pro
Downloads
Home   >   mailing lists

Re: How do I alter an existing column and add a foreign key whichis a Primary key to a table? - Mailing list pgsql-admin

From Karen Goh
Subject Re: How do I alter an existing column and add a foreign key whichis a Primary key to a table?
Date
Msg-id 905425626.2686338.1563721213121@mail.yahoo.com
Whole thread Raw
In response to Re: How do I alter an existing column and add a foreign key which isa Primary key to a table?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: How do I alter an existing column and add a foreign key which isa Primary key to a table?  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-admin
Tree view





On Sunday, July 21, 2019, 10:55:13 PM GMT+8, David G. Johnston <david.g.johnston@gmail.com> wrote:


On Sunday, July 21, 2019, Karen Goh <karenworld@yahoo.com> wrote:

You can't Select s_tutor.zip_code from subject_tutor as zip_code belongs to s_tutor table.

Hence, I wrote my last message about my confusion.



You need to show your entire schema and the queries that are giving you trouble if you want to get help that is less confusing. Though as I wrote before I think your immediate problem is that you don’t have a “tutor” table on which to create the PK.

Is there a way for me to generate an entity table diagram vis pgAdmin4 or PSQL ?

David J.

pgsql-admin by date:

Previous
From: Karen Goh
Date:
Subject: Fw: How do I alter an existing column and add a foreign key whichis a Primary key to a table?
Next
From: "David G. Johnston"
Date:
Subject: Re: How do I alter an existing column and add a foreign key which isa Primary key to a table?