Re: DROP COLUMN ? - Mailing list pgsql-novice

From ERIC Lawson - x52010
Subject Re: DROP COLUMN ?
Date
Msg-id Pine.LNX.4.21.0104261112560.7002-100000@arwen.bioeng.washington.edu
Whole thread Raw
In response to Re: DROP COLUMN ?  (Shay Moreno <moreno@tdk.dk>)
Responses Re: DROP COLUMN ?  (Joel Burton <jburton@scw.org>)
List pgsql-novice
> > 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).

Eric Lawson



pgsql-novice by date:

Previous
From: ERIC Lawson - x52010
Date:
Subject: Re: Locking a Table
Next
From: Joel Burton
Date:
Subject: Re: DROP COLUMN ?