Re: Altering a table - positioning new columns

On Mon, Jan 20, 2003 at 07:24:57AM -0600, Chris Boget wrote:
> 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?  

This is exactly the reason why you should almost always acces your data
through views. Makes life so much easier.

Michael
-- 
Michael Meskes
Email: Michael@Fam-Meskes.De
ICQ: 179140304
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!