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