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*/postgres add foreign key to existing table
UPDATE student
SET name = institute.inst_name
FROM institute
WHERE student.student_id = institute.inst_id;postgre alter table foreign key
ALTER TABLE distributors ADD CONSTRAINT distfk FOREIGN KEY (address) REFERENCES addresses (address) MATCH FULL;psql create table foreign keys
# id_user is the primary key of the table users:
create table lists(
id_list serial not null primary key,
id_user int references users(id_user),
is_temp int
);postgres add foreign key alter table
CREATE TABLE orders (
order_id SERIAL,
dish_name TEXT,
customer_id INTEGER REFERENCES customers (id)
);Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
