Postgresql Altering Table

Question

Is it possible to alter a table to add a new column and make that column a foreign key to another table in a single command in Postgresql? "alter table x add column y id references z(id)" doesn't seem to work as I had hoped.

msi77 · Accepted Answer · 2010-05-25 17:51:02Z

3

You can do it. What is "y id"? May be

alter table x add column y int references z(id)

answered May 25, 2010 at 17:51

msi77

1,6321 gold badge11 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

aib · Accepted Answer · 2010-05-25 18:03:58Z

3

BEGIN
ALTER TABLE ... ADD COLUMN ...
ALTER TABLE ... ADD CONSTRAINT ...
COMMIT

You can't convince me it's not a single command :).

answered May 25, 2010 at 18:03

aib

47.4k10 gold badges75 silver badges79 bronze badges

Collectives™ on Stack Overflow

Postgresql Altering Table

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related