Received: from mail.tbsoa.com (IDENT:root@[63.224.18.124]) by hub.org (8.9.3/8.9.3) with ESMTP id RAA69094 for ; Sat, 1 Apr 2000 17:16:26 -0500 (EST) (envelope-from lagnada@tbsoa.com) Received: from tbswseb (tbsgate.tbsoa.com.18.224.63.in-addr.arpa [63.224.18.122] (may be forged)) by mail.tbsoa.com (8.9.3/8.8.7) with SMTP id RAA01717; Sat, 1 Apr 2000 17:16:12 -0600 From: "Antonio Lagnada" To: "Oliver Elphick" Cc: "Pgsql-sql" Subject: RE: Deleting a COL Date: Sat, 1 Apr 2000 16:17:08 -0600 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 In-Reply-To: <200004012147.e31LkrR16199@linda.lfix.co.uk> Importance: Normal X-Archive-Number: 200004/7 You're right...I tried executing the drop column command but said that it's not yet implemented. When is release 7.0 ready for use? -----Original Message----- From: Oliver Elphick [mailto:olly@lfix.co.uk] Sent: Saturday, April 01, 2000 3:47 PM To: Antonio Lagnada Cc: Pgsql-sql Subject: Re: [SQL] Deleting a COL "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