Re: [ADMIN] adding fields

[Florian Helmberger]

Hi.   You should use     ALTER TABLE <table> ADD COLUMN <column> <datatyp>;   instead. Also, take a look at the docs:     http://www.postgresql.org/idocs/index.php?sql-altertable.html   Cheers, Florian -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jodi Kanter Sent: Friday, January 18, 2002 3:56 PM To: Postgres Admin List Subject: [ADMIN] adding fields I 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. Thanks Jodi _______________________________ Jodi L Kanter BioInformatics Database Administrator University of Virginia (434) 924-2846 [EMAIL PROTECTED]