Answers for "how to add a foreign key 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

postgres add foreign key alter table

CREATE TABLE orders (
    order_id SERIAL,
    dish_name TEXT,
    customer_id INTEGER REFERENCES customers (id)
);

Posted by: Guest on July-09-2021

Code answers related to "how to add a foreign key in postgresql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "how to add a foreign key in postgresql"

Code answers related to "how to add a foreign key in postgresql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "how to add a foreign key in postgresql"

Code answers related to "how to add a foreign key in postgresql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us