Re: RES: Add column and specify the column position in

>This feature seems by a mysql add tu create table command, only mysql can do
>dat.
>
>Alejandro Michelin Salomon
>
>
>

I think it is a very useful feature for postgresql to support it.

If we have this feature supported, I do not have to recreate the table
and resetup all foreign key constraints, views, triggers, etc that are
based on the table.


>-->I am trying to insert one column to a specific position in a table.
>-->
>-->In mysql, I can do:
>-->. create table test(id varchar(3), name varchar(12));
>-->. alter table test add column givename varchar(12) after id;
>-->
>-->I am looking for similar things in postgresql to add a new
>-->column to the
>-->correct position in a table.
>
>-->Could someone hint me please.
>-->Thanks alot!
>
>

>Ying Lu
>
>
>