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

From: Joshua Tolley <eggyknap(at)gmail(dot)com>
To: Vimi <vimmipraj(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5573: How can i add field inbetween in the table while creating
Date: 2010-07-27 13:44:59
Message-ID: 4c4ee2e5.12968e0a.5a8a.208b@mx.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Kevin Grittner 2010-07-27 13:46:09 Re: BUG #5573: How can i add field inbetween in the table while creating
Previous Message Vimi 2010-07-27 07:34:56 BUG #5573: How can i add field inbetween in the table while creating