From: | Jodi Kanter <jkanter(at)virginia(dot)edu> |
---|---|
To: | Florian Helmberger <f(dot)helmberger(at)uptime(dot)at> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: adding fields |
Date: | 2002-01-18 15:20:13 |
Message-ID: | 00b601c1a033$a026acf0$de138f80@virginia.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Thank you. I found this doc just after I sent the email. I appreciate the quick response.
Jodi
----- Original Message -----
From: Florian Helmberger
To: Jodi Kanter
Cc: pgsql-admin(at)postgresql(dot)org
Sent: Friday, January 18, 2002 10:14 AM
Subject: RE: [ADMIN] adding fields
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: pgsql-admin-owner(at)postgresql(dot)org [mailto:pgsql-admin-owner(at)postgresql(dot)org]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
jkanter(at)virginia(dot)edu
From | Date | Subject | |
---|---|---|---|
Next Message | Heather Johnson | 2002-01-18 15:21:11 | Re: adding fields |
Previous Message | Florian Helmberger | 2002-01-18 15:14:39 | Re: adding fields |