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
