Re: Altering live databases

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Gregory Brauer" <greg(at)wildbrain(dot)com>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Altering live databases
Date: 2002-08-08 02:59:12
Message-ID: GNELIHDDFBOCMGBFGEFOCEJGCDAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2002-08-08 09:20:03 Re: Effective usage without unique key -- suggestion
Previous Message Gregory Brauer 2002-08-08 02:52:37 Re: Altering live databases