"Vimi" <vimmipraj(at)gmail(dot)com> wrote:
> How can i add field inbetween in the table while creating
This is not a bug; in the future please post such questions to
pgsql-general.
While the feature you're requesting is likely to appear in a future
release, current releases require that you create a new table with
the desired structure, copy data from the old table into it, drop or
rename the old table, and rename the new table into place. You
would probably want to begin a transaction and acquire an exclusive
lock on the old table before starting this, and commit after the new
table is in its place.
On the other hand, in well-written software, the order of the
columns in the table should make no difference; you might just want
to avoid SELECT * and dodge the whole issue.
-Kevin