Re: Altering a table - positioning new columns

From: Michael Meskes <meskes(at)postgresql(dot)org>
To: Chris Boget <chris(at)wild(dot)net>
Cc: PGSql General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Altering a table - positioning new columns
Date: 2003-01-20 19:38:18
Message-ID: 20030120193818.GA16594@feivel.fam-meskes.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)Fam-Meskes(dot)De
ICQ: 179140304
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2003-01-20 19:56:19 Re: select like and indexes
Previous Message Greg Stark 2003-01-20 19:28:29 Re: Question, how intelligent is optimizer with subplans?