drop column?

From: Jodi Kanter <jkanter(at)virginia(dot)edu>
To: Postgres Admin List <pgsql-admin(at)postgresql(dot)org>
Subject: drop column?
Date: 2002-01-23 19:54:43
Message-ID: 008401c1a447$cd0402f0$de138f80@virginia.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I cannot seem to locate any documentation about removing a column that I just added to a table. There is no data in that particular column but there is in the rest of the table.
Can I remove this column or will I need to drop the entire table and restore from backup?
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 Nick Fankhauser 2002-01-23 20:25:59 Re: drop column?
Previous Message Tom Lane 2002-01-23 19:05:21 Re: sub selects