Re: 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