Re: adding fields - Mailing list pgsql-admin

----- Original Message -----

From: Florian Helmberger

To: Jodi Kanter

Cc: pgsql-admin@postgresql.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@postgresql.org [mailto:pgsql-admin-owner@postgresql.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@virginia.edu