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

["Alejandro Michelin Salomon \( Adinet \)" <alejmsg@xxxxxxxxxxxxx>]

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@xxxxxxxxxxxxxx 
-->[mailto:pgsql-general-owner@xxxxxxxxxxxxxx] Em nome de Emi Lu
-->Enviada em: quarta-feira, 17 de maio de 2006 18:21
-->Para: pgsql-general@xxxxxxxxxxxxxx
-->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