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

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

2006-05-17 Thread Alejandro Michelin Salomon \( Adinet \)
>Para: pgsql-general@postgresql.org -->Assunto: [GENERAL] Add column and specify the column -->position in a table --> --> -->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

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

2006-05-17 Thread Emi Lu
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 po