| From: | Joel Burton <jburton(at)scw(dot)org> |
|---|---|
| To: | ERIC Lawson - x52010 <eric(at)bioeng(dot)washington(dot)edu> |
| Cc: | Shay Moreno <moreno(at)tdk(dot)dk>, "'esavas(at)mac(dot)com'" <esavas(at)mac(dot)com>, pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: DROP COLUMN ? |
| Date: | 2001-04-26 18:48:15 |
| Message-ID: | Pine.LNX.4.21.0104261446190.1139-100000@olympus.scw.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Thu, 26 Apr 2001, ERIC Lawson - x52010 wrote:
> > > How can we drop a column from a table ?
> >
> > It seems we can't.
>
> The SQL command ALTER TABLE DROP COLUMN isn't supported; see
>
> http://www.ca.postgresql.org/docs/faq-english.html#4.5
>
> for a work-around; note that I dimly recall some caveats regarding
> using this workaround, so tread lightly (back everything up first, and
> test the results thoroughly afterwards).
Also a new tutorial on this & other schema changes at
http://techdocs.postgresql.org/techdocs/updatingcolumns.html
--
Joel Burton <jburton(at)scw(dot)org>
Director of Information Systems, Support Center of Washington
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shay Moreno | 2001-04-27 07:11:16 | Re: Locking a Table |
| Previous Message | ERIC Lawson - x52010 | 2001-04-26 18:26:50 | Re: Locking a Table |