adding fields

From: Jodi Kanter <jkanter(at)virginia(dot)edu>
To: Postgres Admin List <pgsql-admin(at)postgresql(dot)org>
Subject: adding fields
Date: 2002-01-18 14:55:59
Message-ID: 00a401c1a030$3dfd0130$de138f80@virginia.edu
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Florian Helmberger 2002-01-18 15:14:39 Re: adding fields
Previous Message Martins Zarins 2002-01-18 10:00:41 Performance