Re: DROP COLUMN ?

From: ERIC Lawson - x52010 <eric(at)bioeng(dot)washington(dot)edu>
To: Shay Moreno <moreno(at)tdk(dot)dk>
Cc: "'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:16:57
Message-ID: Pine.LNX.4.21.0104261112560.7002-100000@arwen.bioeng.washington.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message ERIC Lawson - x52010 2001-04-26 18:26:50 Re: Locking a Table
Previous Message Stephen M. Ford 2001-04-26 15:06:17 still having installing problems