| From: | Karen Goh <karenworld(at)yahoo(dot)com> |
|---|---|
| To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
| Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org, Ron <ronljohnsonjr(at)gmail(dot)com> |
| Subject: | Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? |
| Date: | 2019-07-21 15:00:13 |
| Message-ID: | 905425626.2686338.1563721213121@mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-sql |
On Sunday, July 21, 2019, 10:55:13 PM GMT+8, David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
On Sunday, July 21, 2019, Karen Goh <karenworld(at)yahoo(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2019-07-21 15:06:06 | Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? |
| Previous Message | Karen Goh | 2019-07-21 14:56:07 | Fw: How do I alter an existing column and add a foreign key which is a Primary key to a table? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2019-07-21 15:06:06 | Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? |
| Previous Message | Karen Goh | 2019-07-21 14:56:07 | Fw: How do I alter an existing column and add a foreign key which is a Primary key to a table? |