RE: Deleting a COL

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
ID32B8FAA1                ========================================    "Therefore, if anyone is in Christ, he is a new
 creation; the old has gone, the new has come."                     II Corinthians 5:17