Answers for "set foreign key as primary key postgres"

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 "set foreign key as primary key postgres"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "set foreign key as primary key postgres"

Code answers related to "set foreign key as primary key postgres"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "set foreign key as primary key postgres"

Code answers related to "set foreign key as primary key postgres"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us