Answers for "postgresql create table constraint foreign key example"

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 "postgresql create table constraint foreign key example"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "postgresql create table constraint foreign key example"

Code answers related to "postgresql create table constraint foreign key example"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "postgresql create table constraint foreign key example"

Code answers related to "postgresql create table constraint foreign key example"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us