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@scw.org>
Director of Information Systems, Support Center of Washington