Re: Altering a table - positioning new columns - Mailing list pgsql-general

From Manfred Koizar
Subject Re: Altering a table - positioning new columns
Date
Msg-id tk4o2vsqlcthdaq0ckcrhnrb0b4r00bt8o@4ax.com
Whole thread Raw
In response to Altering a table - positioning new columns  ("Chris Boget" <chris@wild.net>)
List pgsql-general
On Mon, 20 Jan 2003 07:24:57 -0600, "Chris Boget" <chris@wild.net>
wrote:
>give me a
>definitive yes or no.

No.  Sorry.  If column order is important, you have to create a new
table and copy over the data, then drop the old table and rename the
new one.  Of course this has its drawbacks, if there are triggers,
foreign keys, ...

Servus
 Manfred

pgsql-general by date:

Previous
From: Gregory Seidman
Date:
Subject: Re: passwords and 7.3
Next
From: Tom Lane
Date:
Subject: Re: problems configuring with readline and zlib