Altering a table - positioning new columns - Mailing list pgsql-general

From Chris Boget
Subject Altering a table - positioning new columns
Date
Msg-id 023c01c2c087$53a5d4d0$8c01a8c0@ENTROPY
Whole thread Raw
Responses Re: Altering a table - positioning new columns
Re: Altering a table - positioning new columns
Re: Altering a table - positioning new columns
List pgsql-general
In MySQL, when adding a new column to a table, you could
position it relative to another column already in the DB.  IOW,
you could do something like this:

ALTER TABLE blah ADD COLUMN newcol AFTER anothercol.

Is something like this possible in PG?  Or are _all_ new columns
added to the end of the column list?
I've searched through the docs and couldn't find that this was
possible and some tests have come up with errors.  That said,
I'm still new enough to where I can't be sure I'm doing it the right
way for PG and am hoping one of you guys can give me a
definitive yes or no.

thnx,
Chris


pgsql-general by date:

Previous
From: Jukka Väänänen
Date:
Subject: intervals in 7.3.1
Next
From: "kanchana"
Date:
Subject: Re: Fw: configure error with krb5