Re: adding fields
| От | Heather Johnson |
|---|---|
| Тема | Re: adding fields |
| Дата | |
| Msg-id | 00cc01c1a033$c2df39b0$510b10ac@sephie обсуждение исходный текст |
| Ответ на | adding fields (Jodi Kanter <jkanter@virginia.edu>) |
| Список | pgsql-admin |
Hi Jodi--
No, you shouldn't have to go to that amount of trouble. Try this instead (change the name of the table, the default value, the column name, and the column type to suit your needs):
BEGIN WORK;
LOCK TABLE table_adding_stuff_to IN ACCESS EXCLUSIVE MODE;
LOCK TABLE table_adding_stuff_to IN ACCESS EXCLUSIVE MODE;
ALTER TABLE table_adding_stuff_to ADD COLUMN new_column_name COLUMNTYPE;
ALTER TABLE table_adding_stuff_to ALTER COLUMN new_column_name SET DEFAULT 'default value';
COMMIT WORK;
ALTER TABLE table_adding_stuff_to ALTER COLUMN new_column_name SET DEFAULT 'default value';
COMMIT WORK;
Then you can do:
BEGIN WORK;
UPDATE table_adding_stuff_to SET new_column_name = 'default value';
COMMIT WORK;
Heather
----- Original Message -----From: Jodi KanterSent: Friday, January 18, 2002 9:55 AMSubject: [ADMIN] adding fieldsI need to add a field to an existing table that contains a good amount of data. Do I need to drop table, recreate, and then reload data to do this? I cannot seem to find any documentation to say otherwise.ThanksJodi_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter@virginia.edu
В списке pgsql-admin по дате отправления: