Re: BUG #5573: How can i add field inbetween in the table while creating

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