Re: Altering live databases - Mailing list pgsql-sql

From Christopher Kings-Lynne
Subject Re: Altering live databases
Date
Msg-id GNELIHDDFBOCMGBFGEFOCEJGCDAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to Re: Altering live databases  (Gregory Brauer <greg@wildbrain.com>)
List pgsql-sql
> Indeed I am.  Thanks.
>
> One more question... is there yet a way to drop a column from a table?
> If not will that come with 7.3?

You can select the table into a temp table without the column you want
dropped, drop the old one, rename the temp one and recreate all your
indexes, etc.  Nasty.  However, 7.3 has DROP COLUMN support as of a week
ago.

Chris



pgsql-sql by date:

Previous
From: Gregory Brauer
Date:
Subject: Re: Altering live databases
Next
From: Richard Huxton
Date:
Subject: Re: Effective usage without unique key -- suggestion