Re: add column specify position

[Scott Frankel <frankel@xxxxxxxxxxxxx>]

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@xxxxxxxxxxxxx> 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/