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 B0FB8D1DCC0 for ; Thu, 8 Apr 2004 11:39:18 -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 60671-08 for ; Thu, 8 Apr 2004 11:39:17 -0300 (ADT) Received: from localhost (limacorp.com [66.216.127.144]) by svr1.postgresql.org (Postfix) with SMTP id 5C304D1DC1E for ; Thu, 8 Apr 2004 11:39:14 -0300 (ADT) Received: (qmail 18320 invoked by uid 506); 8 Apr 2004 14:39:18 -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.031677 secs); 08 Apr 2004 14:39:18 -0000 Received: from unknown (HELO limacorp.com) (24.123.167.82) by garbanzo.limacorp.com with SMTP; 8 Apr 2004 14:39:18 -0000 Message-ID: <407555C3.1030209@limacorp.com> Date: Thu, 08 Apr 2004 09:38:11 -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: [Fwd: Re: 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/152 X-Sequence-Number: 13125 Anyone know this list member, who was kind enought to reply? -------- Original Message -------- Subject: Re: [ADMIN] Location of a new column Date: Thu, 8 Apr 2004 06:58:56 -0700 From: "scott" To: "Terry Hampton" References: <40754755.2020603@limacorp.com> FUCK U ----- Original Message ----- From: "Terry Hampton" To: Sent: Thursday, April 08, 2004 5:36 AM Subject: [ADMIN] Location of a new column > > 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 > > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org -- Terry L. Hampton Project Manager LimaCorp, LLC www.limacorp.com 513.587.1874