the position doesn't really matter in any relational structure.. does it? On 5/17/06, Emi Lu <emilu@xxxxxxxxxxxxxxxxx> 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
