Received: from mail.enterprise.net (mail.enterprise.net [194.72.192.18]) by hub.org (8.9.3/8.9.3) with ESMTP id QAA66893 for ; Sat, 1 Apr 2000 16:49:49 -0500 (EST) (envelope-from olly@lfix.co.uk) Received: from linda.lfix.co.uk (max02-067.enterprise.net [194.72.195.187]) by mail.enterprise.net (8.8.5/8.8.5) with ESMTP id WAA19288; Sat, 1 Apr 2000 22:49:47 +0100 (GMT/BST) Received: from lfix.co.uk (localhost [127.0.0.1]) by linda.lfix.co.uk (8.10.0/8.10.0/Debian 8.10.0-1) with ESMTP id e31LkrR16199; Sat, 1 Apr 2000 22:47:02 +0100 Message-Id: <200004012147.e31LkrR16199@linda.lfix.co.uk> X-Authentication-Warning: linda.lfix.co.uk: Host localhost [127.0.0.1] claimed to be lfix.co.uk X-Mailer: exmh version 2.1.1 10/15/1999 (debian) To: "Antonio Lagnada" cc: "Pgsql-sql" Subject: Re: Deleting a COL In-Reply-To: Message from "Antonio Lagnada" of "Sat, 01 Apr 2000 14:34:10 MDT." References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Date: Sat, 01 Apr 2000 22:46:53 +0100 From: "Oliver Elphick" X-Archive-Number: 200004/5 "Antonio Lagnada" wrote: > >Does anyone know how to delete a column in PostgreSQL? >I cannot find the SQL command to do it. ALTER TABLE DROP COLUMN colname (but I don't think it's supported before release 7.0) -- Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight http://www.lfix.co.uk/oliver PGP key from public servers; key ID 32B8FAA1 ======================================== "Therefore, if anyone is in Christ, he is a new creation; the old has gone, the new has come." II Corinthians 5:17