Postgres Pro
Downloads
Home   >   mailing lists

Re: add column specify position - Mailing list pgsql-general

From Scott Frankel
Subject Re: add column specify position
Date
Msg-id 566194E1-70D7-4B06-B900-D1037FDE6C26@circlesfx.com
Whole thread Raw
In response to Re: add column specify position  (Shoaib Mir <shoaibmir@gmail.com>)
List pgsql-general
Tree view

Excellent!  Thanks for providing the link.  I think the 'add columns and move data' option would best fit my needs.

Thanks!
Scott




On Feb 2, 2010, at 11:44 PM, Shoaib Mir wrote:

On Wed, Feb 3, 2010 at 4:14 PM, Scott Frankel <frankel@circlesfx.com> wrote:

Hi all,

Is it possible to specify a position when adding a column to a table?


Not possible, but have a read of http://wiki.postgresql.org/wiki/Alter_column_position and look at the alternative options. 

--
Shoaib Mir
http://shoaibmir.wordpress.com/










pgsql-general by date:

Previous
From: Andrej
Date:
Subject: Re:
Next
From: "Wang, Mary Y"
Date:
Subject: Re: PQendcopy:resetting connection Problem and Cannot insert a duplicate key into unique index