X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 75A2B4763DA for ; Thu, 30 Jan 2003 21:59:50 -0500 (EST) Received: from rtlocal.trade-india.com (mail-relay.trade-india.com [203.196.129.235]) by postgresql.org (Postfix) with SMTP id C449047600E for ; Thu, 30 Jan 2003 21:59:45 -0500 (EST) Received: (qmail 30396 invoked from network); 31 Jan 2003 02:54:48 -0000 Received: from ns1.trade-india.com (HELO www.trade-india.com) (66.234.10.14) by infocom-236-129-del.trade-india.com with SMTP; 31 Jan 2003 02:54:48 -0000 Received: (qmail 29620 invoked by uid 99); 31 Jan 2003 02:58:31 -0000 Received: from 219.65.233.66 (proxying for 219.65.233.66) (SquirrelMail authenticated user mallah) by mail.trade-india.com with HTTP; Fri, 31 Jan 2003 08:28:31 +0530 (IST) Message-ID: <22043.219.65.233.66.1043981911.squirrel@mail.trade-india.com> Date: Fri, 31 Jan 2003 08:28:31 +0530 (IST) Subject: Re: How to rename and drop a column in pg7.3? From: To: In-Reply-To: References: X-Priority: 3 Importance: Normal X-MSMail-Priority: Normal Cc: X-Mailer: SquirrelMail (version 1.2.6) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/516 X-Sequence-Number: 11381 Hmmm... both are supported in 7.3.x ALTER TABLE rtfm RENAME f1 to f2 ; ALTER TABLE rtfm DROP COLUMN f3; hope it helps. regds mallah. > > I need to rename and remove columns of a table. Is any new way to accompl= ish the two tasks in > 7.3? I have searched the online document and don't see any related infor= mation. > > Thanks, > > Vernon > > > > ---------------------------(end of broadcast)--------------------------- = TIP 2: you can get off > all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) ----------------------------------------- Get your free web based email at trade-india.com. "India's Leading B2B eMarketplace.!" http://www.trade-india.com/