Re: Altering a table - positioning new columns

From: Manfred Koizar <mkoi-pg(at)aon(dot)at>
To: "Chris Boget" <chris(at)wild(dot)net>
Cc: "PGSql General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Altering a table - positioning new columns
Date: 2003-01-20 15:19:43
Message-ID: tk4o2vsqlcthdaq0ckcrhnrb0b4r00bt8o@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 20 Jan 2003 07:24:57 -0600, "Chris Boget" <chris(at)wild(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-01-20 15:22:01 Re: problems configuring with readline and zlib
Previous Message Renê Salomão 2003-01-20 14:22:14 ERROR: No one parent tuple was found