Answers for "how to add foreign key with another table in postgresql"

postgres add foreign key to existing table

ALTER TABLE tblA ADD COLUMN colA VARCHAR(10); /* 1st add column */
ALTER TABLE tblA ADD CONSTRAINT colA /* Make colA on tblA a foreign key */
FOREIGN KEY (colA) REFERENCES tblB (colB); /* colB must be a pk on tblB*/

Posted by: Guest on August-27-2021

Code answers related to "how to add foreign key with another table in postgresql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "how to add foreign key with another table in postgresql"

Code answers related to "how to add foreign key with another table in postgresql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "how to add foreign key with another table in postgresql"

Code answers related to "how to add foreign key with another table in postgresql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us