Re: [GENERAL] Add column and specify the column position in a table

2006-05-17 Thread Samer Abukhait
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 co

Re: [GENERAL] Add column and specify the column position in a table

2006-05-17 Thread Joshua D. Drake
Emi Lu 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