Postgres Pro
Downloads
Home   >   mailing lists

Re: adding fields - Mailing list pgsql-admin

From Florian Helmberger
Subject Re: adding fields
Date
Msg-id OPEOLKEAAIMGBAMJNACKAEGMDHAA.f.helmberger@uptime.at
Whole thread Raw
In response to adding fields  (Jodi Kanter <jkanter@virginia.edu>)
List pgsql-admin
Tree view
Hi.
 
You should use
 
  ALTER TABLE <table> ADD COLUMN <column> <datatyp>;
 
instead. Also, take a look at the docs:
 
 
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

 

 

 

pgsql-admin by date:

Previous
From: "Heather Johnson"
Date:
Subject: Re: adding fields
Next
From: "Esger Abbink"
Date:
Subject: problem concerning vacuum/statistics & query performance