Postgres Pro
Downloads
Home   >   mailing lists

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

From Scott Ribe
Subject Re: How do I alter an existing column and add a foreign key which isa Primary key to a table?
Date
Msg-id BABAFCAB-0E7B-4AF9-A89C-80EC8D35201A@elevated-dev.com
Whole thread Raw
In response to Re: How do I alter an existing column and add a foreign key whichis a Primary key to a table?  (Karen Goh <karenworld@yahoo.com>)
List pgsql-admin
Tree view 
This forum is recommended for questions regarding administration of PostgreSQL, which your questions are not related
to.pgsql-gernal or pgsql-sql would be better fits. 

But I'd strongly suggest that you pause and learn SQL basics in a structured way. You've said several times that you've
beenwriting queries for a long time, but your questions here demontrate a serious lack of understanding of the basics.
Mypersonal recommendation: 

https://www.postgresql.org/docs/11/tutorial-sql.html

Or, for a quicker start:

https://www.postgresql.org/docs/11/tutorial-sql.html
https://www.postgresql.org/docs/11/sql.html

--
Scott Ribe
scott_ribe@elevated-dev.com
https://www.linkedin.com/in/scottribe/

pgsql-admin by date:

Previous
From: Karen Goh
Date:
Subject: Re: How do I alter an existing column and add a foreign key whichis a Primary key to a table?
Next
From: Tom Lane
Date:
Subject: Re: pguint Installation error in PostgreSQL server version 11.2