X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 796099FA2C8 for ; Wed, 17 May 2006 18:22:38 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 12799-09 for ; Wed, 17 May 2006 18:22:33 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from perseverance.encs.concordia.ca (perseverance-96.encs.concordia.ca [132.205.96.94]) by postgresql.org (Postfix) with ESMTP id 6958F9FA279 for ; Wed, 17 May 2006 18:22:33 -0300 (ADT) Received: from [132.205.47.225] (emilu@cacao.encs.concordia.ca [132.205.47.225]) by perseverance.encs.concordia.ca (8.13.6/8.13.6) with ESMTP id k4HLMWue015695 for ; Wed, 17 May 2006 17:22:32 -0400 Message-ID: <446B9418.3080700@encs.concordia.ca> Date: Wed, 17 May 2006 17:22:32 -0400 From: Emi Lu Reply-To: emilu@encs.concordia.ca User-Agent: Mozilla Thunderbird 1.0.7 (X11/20050923) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Add column and specify the column position in a table Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Scanned-By: MIMEDefang 2.43 on perseverance.encs.concordia.ca at 2006/05/17 17:22:32 EDT X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/122 X-Sequence-Number: 25153 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