ALTER TABLE - add several columns
От
Fuchs Clemens
Тема
ALTER TABLE - add several columns
Дата
Msg-id
9DDD01E6B277D511B22300A0C9EEE776025D524E@LNZP106A
Список
Дерево обсуждения
ALTER TABLE - add several columns Fuchs Clemens <clemens.fuchs@siemens.com>
Re: ALTER TABLE - add several columns Janning Vygen <vygen@gmx.de>
Hi,
I just want to add several columns to an existing table. Do I have to call a statements like below for each new column, or is there a possibility to do it at once?
- existing table: test
- columns to add: col1 (FK), col2
ALTER TABLE test ADD col1 INT2 NULL;
ALTER TABLE test ADD CONSTRAINT col1_fk FOREIGN KEY (col1) REFERENCES xy(col1);
ALTER TABLE test ADD col2 INT2 NULL;
I'd rather like to execute a statement like this:
ALTER TABLE test ADD (
col1 INT2 NULL,
col2 INT2 NULL,
FOREIGN KEY (col1) REFERENCES xy(col1)
);
thx,
Clemens
В списке pgsql-general по дате отправления