| From: | Shay Moreno <moreno(at)tdk(dot)dk> |
|---|---|
| To: | "'esavas(at)mac(dot)com'" <esavas(at)mac(dot)com>, pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: DROP COLUMN ? |
| Date: | 2001-04-26 12:36:52 |
| Message-ID: | 5D38890DAE46D41186A800508B6F7187026FFE3F@oestmb010-b0.tdk.dk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
> Simple question, however could not find anything for it.
Neither could I. If you check the docs (go to
http://postgresql.org./, then to the users' lounge until you find
http://www.ca.postgresql.org/users-lounge/docs/7.1/reference/sql-altertable.
html at the Reference Manual) you will see the ALTER TABLE command doesn't
include a DROP COLUMN action.
> How can we drop a column from a table ?
It seems we can't.
--
_
/ \ Leandro Guimarães Faria Corcete Dutra +55 (11) 3040 8913
\ / Amdocs Brasil Ltda at Tele Danmark +45 3387 5214
X http://geocities.com./lgdutra/ mailto:leandrod(at)amdocs(dot)com
/ \ Campanha fita ASCII mailto:moreno(at)tdk(dot)dk
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Carsten Huettl | 2001-04-26 12:54:42 | Update postgres 6.5 -> 7.0 |
| Previous Message | Tom Lane | 2001-04-25 20:42:21 | Re: install problem |