Request a Demo
Home   >   mailing lists

Re: Alter table - Mailing list pgsql-general

From Richard Huxton
Subject Re: Alter table
Date
Msg-id 200307301814.55624.dev@archonet.com
Whole thread Raw
In response to Alter table  ("Guillaume Houssay" <ghoussay@noos.fr>)
List pgsql-general
Tree view 
On Wednesday 30 July 2003 17:21, Guillaume Houssay wrote:
> I am looking for the SQL query to add a column in a table and having the
> column at specific position in the table (not at the end of the table).

Sorry - you'll need to dump and restore the table. PG only adds columns at the
end.

--
  Richard Huxton
  Archonet Ltd

pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: Alter table
Next
From: Vitor Tortorello
Date:
Subject: plpython and current_timestamp / current_user