Re: [GENERAL] Change table structure.
От | Stuart Rison |
---|---|
Тема | Re: [GENERAL] Change table structure. |
Дата | |
Msg-id | Pine.LNX.4.10.9909231601281.25020-100000@bsmlx17 обсуждение исходный текст |
Ответ на | Change table structure. ("Michal A. Kowalski" <mak@minfo.com.pl>) |
Ответы |
Re: [GENERAL] Change table structure.
|
Список | pgsql-general |
AFAIK, you can add and and rename columns no problem: functions=> \h alter table Command: alter table Description: add/rename attributes, rename tables Syntax: ALTER TABLE class_name [*] ADD COLUMN attr type ALTER TABLE class_name [*] RENAME [COLUMN] attr1 TO attr2 ALTER TABLE class_name1 RENAME TO class_name2 But you can't drop a column without a DROP and CREATE again. On Thu, 23 Sep 1999, Michal A. Kowalski wrote: > Hi, > > is there any way to change table structure without doing DROP and CREATE > again? > > Regards, > MAK. > ___________________________________________________________________________ > -- Michal A. Kowalski -- http://www.minfo.com.pl -- mak@minfo.com.pl -- > > ************ > Stuart C. G. Rison Department of Biochemistry and Molecular Biology 6th floor, Darwin Building, University College London (UCL) Gower Street, London, WC1E 6BT, United Kingdom Tel. 0207 504 2303, Fax. 0207 380 7033 e-mail: rison@biochem.ucl.ac.uk
В списке pgsql-general по дате отправления: