Postgres Pro
Downloads
Home   >   mailing lists

Re: alter table add column - specify where the column will go? - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: alter table add column - specify where the column will go?
Date
Msg-id icifum$c8f$1@dough.gmane.org
Whole thread Raw
In response to alter table add column - specify where the column will go?  (Alexander Farber <alexander.farber@gmail.com>)
List pgsql-general
Tree view 
Alexander Farber, 24.11.2010 08:42:
> is there a syntax to add a column not at the last place

No, because the order of the column is irrelevant (just as there is no order on the rows in a table)
Simply select them in the order you like to have.

Thomas

pgsql-general by date:

Previous
From: Szymon Guz
Date:
Subject: Re: alter table add column - specify where the column will go?
Next
From: Dmitriy Igrishin
Date:
Subject: Re: alter table add column - specify where the column will go?