Re: alter table add column - specify where the column will go?

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: alter table add column - specify where the column will go?
Date: 2010-11-24 07:47:35
Message-ID: icifum$c8f$1@dough.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dmitriy Igrishin 2010-11-24 07:48:36 Re: alter table add column - specify where the column will go?
Previous Message Szymon Guz 2010-11-24 07:45:59 Re: alter table add column - specify where the column will go?