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(at)lfix(dot)co(dot)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(dot)Elphick(at)lfix(dot)co(dot)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