Re: BUG #5573: How can i add field inbetween in the table while creating - Mailing list pgsql-bugs

From Joshua Tolley
Subject Re: BUG #5573: How can i add field inbetween in the table while creating
Date
Msg-id 4c4ee2e5.12968e0a.5a8a.208b@mx.google.com
Whole thread Raw
In response to BUG #5573: How can i add field inbetween in the table while creating  ("Vimi" <vimmipraj@gmail.com>)
List pgsql-bugs
On Tue, Jul 27, 2010 at 07:34:56AM +0000, Vimi wrote:
> If i have already crreated one table and i wan to add one more field into
> table but its ibetween imean if i have 4 fields are already created and if i
> want to add one more field aat 2nd index then how can i do in postgre. i
> tried in Navicat but no luck.

You can't change column order without dropping and recreating the columns,
recreating the table, or something similar. Sorry.

--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com

pgsql-bugs by date:

Previous
From: "Vimi"
Date:
Subject: BUG #5573: How can i add field inbetween in the table while creating
Next
From: "Kevin Grittner"
Date:
Subject: Re: BUG #5573: How can i add field inbetween in the table while creating