X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id B9B87D1B443 for ; Wed, 31 Dec 2003 06:01:24 +0000 (GMT) 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 38114-04 for ; Wed, 31 Dec 2003 02:00:35 -0400 (AST) Received: from delta.greatindianproducts.com (unknown [61.16.132.195]) by svr1.postgresql.org (Postfix) with ESMTP id E043BD1B446 for ; Wed, 31 Dec 2003 02:00:31 -0400 (AST) Received: (from ashok@localhost) by delta.greatindianproducts.com (8.11.6/8.11.6) id hBVBYRv14419; Wed, 31 Dec 2003 11:34:27 GMT X-Authentication-Warning: delta.greatindianproducts.com: ashok set sender to ashok@kalculate.com using -f Subject: Re: drop column From: Ashok Chauhan To: pgsql-admin@postgresql.org In-Reply-To: <1072793069.1687.17.camel@Bhuvan.bksys.co.in> References: <1072804035.3479.6.camel@delta.greatindianproducts.com> <1072793069.1687.17.camel@Bhuvan.bksys.co.in> Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.3 (1.0.3-4) Date: 31 Dec 2003 11:34:26 +0000 Message-Id: <1072870466.14188.2.camel@delta.greatindianproducts.com> Mime-Version: 1.0 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/348 X-Sequence-Number: 11854 On Tue, 2003-12-30 at 14:04, A.Bhuvaneswaran wrote: > > A command for remove the column but it not work > > it gives parse error > > ALTER TABLE tablename DROP COLUMN fieldname; > > drop column feature is implemented since 7.3. So, you please check out > your version. > > regards, > bhuvaneswaran hello thanks for reply. yes i am using 7.2 version. so any other option except drop the table and re-create it. Ashok