Add Column BEFORE/AFTER another column

From: Matthew <mboehm(at)voilaip(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Add Column BEFORE/AFTER another column
Date: 2007-08-24 20:55:42
Message-ID: 46CF45CE.306@voilaip.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi gang,
In MySQL it is possible to add a column before/after another column. I
have not been able to find such syntax in the Postgres manual. Does this
ability exist?

Is my only solution to create a new table with the new column, copy the
data, delete the old table and rename the new one?

TIA,
Matthew

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2007-08-24 21:11:18 Re: Add Column BEFORE/AFTER another column
Previous Message Cody Pisto 2007-08-24 20:47:15 Re: lc_collate issue