On 2010-02-03, Scott Frankel wrote:
>
> Hi all,
>
> Is it possible to specify a position when adding a column to a table?
no.
> I want to swap one column for another without losing the column's
> position. eg: given that 'foo' is the 5th column in an 8 column
> table, I want to replace it
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
wrote:
Hi all,
Is it possible to specify a position when ad
On Wed, Feb 3, 2010 at 4:14 PM, Scott Frankel 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://shoaibm
Hi Scott
Scott Frankel wrote:
Hi all,
Is it possible to specify a position when adding a column to a table?
No not AFAIK.
I want to swap one column for another without losing the column's
position. eg: given that 'foo' is the 5th column in an 8 column table,
I want to replace it with a 'b
