X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id B0BF2D1D412 for ; Thu, 8 Apr 2004 10:37:44 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 34536-03 for ; Thu, 8 Apr 2004 10:37:40 -0300 (ADT) Received: from localhost (limacorp.com [66.216.127.144]) by svr1.postgresql.org (Postfix) with SMTP id 4D3F4D1D091 for ; Thu, 8 Apr 2004 10:37:37 -0300 (ADT) Received: (qmail 16556 invoked by uid 506); 8 Apr 2004 13:37:41 -0000 Received: from thampton@limacorp.com by garbanzo.limacorp.com by uid 506 with qmail-scanner-1.16 (spamassassin: 2.55. Clear:. Processed in 0.025436 secs); 08 Apr 2004 13:37:41 -0000 Received: from unknown (HELO limacorp.com) (24.123.167.82) by garbanzo.limacorp.com with SMTP; 8 Apr 2004 13:37:40 -0000 Message-ID: <40754755.2020603@limacorp.com> Date: Thu, 08 Apr 2004 08:36:37 -0400 From: Terry Hampton User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.1) Gecko/20021003 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Location of a new column Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/146 X-Sequence-Number: 13119 All, I thought this was answered before, but I could not find anything in my saved email. I need to ALTER a table to add a new column. I want the new column to be between two existing columns, however. Didn't I see mention of an "AFTER" parameter that specified the location in the table where the new column should be placed ? Maybe not .......... How then, can I specify the location within the table, of new column ? 7.3 & RH Linux Many thanks ! Terry -- Terry L. Hampton Project Manager LimaCorp, LLC www.limacorp.com 513.587.1874