Re: Deleting a COL - Mailing list pgsql-sql

From Oliver Elphick
Subject Re: Deleting a COL
Date
Msg-id 200004012147.e31LkrR16199@linda.lfix.co.uk
Whole thread Raw
In response to Deleting a COL  ("Antonio Lagnada" <lagnada@tbsoa.com>)
Responses RE: Deleting a COL  ("Antonio Lagnada" <lagnada@tbsoa.com>)
Re: Deleting a COL  ("John M. Flinchbaugh" <glynis@butterfly.hjsoft.com>)
List pgsql-sql
"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  
 




pgsql-sql by date:

Previous
From: "Antonio Lagnada"
Date:
Subject: Deleting a COL
Next
From: "Antonio Lagnada"
Date:
Subject: oid field