| From: | "Oliver Elphick" <olly(at)lfix(dot)co(dot)uk> |
|---|---|
| To: | "Antonio Lagnada" <lagnada(at)tbsoa(dot)com> |
| Cc: | "Pgsql-sql" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Deleting a COL |
| Date: | 2000-04-01 21:46:53 |
| Message-ID: | 200004012147.e31LkrR16199@linda.lfix.co.uk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Antonio Lagnada | 2000-04-01 22:15:00 | oid field |
| Previous Message | Antonio Lagnada | 2000-04-01 20:34:10 | Deleting a COL |