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 B5C77D1D300 for ; Thu, 8 Apr 2004 13:08:51 -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 94259-09 for ; Thu, 8 Apr 2004 13:08:48 -0300 (ADT) Received: from megazone.bigpanda.com (megazone.bigpanda.com [64.147.171.210]) by svr1.postgresql.org (Postfix) with ESMTP id 1312BD1D098 for ; Thu, 8 Apr 2004 13:08:48 -0300 (ADT) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id D32AF35251; Thu, 8 Apr 2004 09:08:46 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id D1AE835243; Thu, 8 Apr 2004 09:08:46 -0700 (PDT) Date: Thu, 8 Apr 2004 09:08:46 -0700 (PDT) From: Stephan Szabo To: Terry Hampton Cc: pgsql-admin@postgresql.org Subject: Re: [Fwd: Re: Location of a new column] In-Reply-To: <407555C3.1030209@limacorp.com> Message-ID: <20040408090750.P96411@megazone.bigpanda.com> References: <407555C3.1030209@limacorp.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/155 X-Sequence-Number: 13128 On Thu, 8 Apr 2004, Terry Hampton wrote: > Anyone know this list member, > who was kind enought to reply? No, but he's sent me private messages of the sort in the past (and in fact also sent on in response to my reply to this message). > -------- 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 ?