the position doesn't really matter in any relational structure.. does it?

On 5/17/06, Emi Lu <[EMAIL PROTECTED]> wrote:
Hello,

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





---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to