RES: Add column and specify the column position in a table

Hi Ying:

This feature seems by a mysql add tu create table command, only mysql can do
dat.

Alejandro Michelin Salomon

-->-----Mensagem original-----
-->De: pgsql-general-owner(at)postgresql(dot)org
-->[mailto:pgsql-general-owner(at)postgresql(dot)org] Em nome de Emi Lu
-->Enviada em: quarta-feira, 17 de maio de 2006 18:21
-->Para: pgsql-general(at)postgresql(dot)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(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
-->
-->
-->--
-->No virus found in this incoming message.
-->Checked by AVG Free Edition.
-->Version: 7.1.392 / Virus Database: 268.6.0/341 - Release
-->Date: 16/5/2006
-->
-->
-->--
-->No virus found in this incoming message.
-->Checked by AVG Free Edition.
-->Version: 7.1.392 / Virus Database: 268.6.0/341 - Release
-->Date: 16/5/2006
-->
-->

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.392 / Virus Database: 268.6.0/341 - Release Date: 16/5/2006

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.392 / Virus Database: 268.6.0/341 - Release Date: 16/5/2006