Re: Is there a way to drop a column?

From: "G(dot) Anthony Reina" <reina(at)nsi(dot)edu>
To: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
Cc: "pgsql-general(at)hub(dot)org" <pgsql-general(at)hub(dot)org>
Subject: Re: Is there a way to drop a column?
Date: 2000-05-30 19:23:53
Message-ID: 39341549.CAB9A898@nsi.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Karel Zak wrote:

>
> > I can see a way to "alter table ... add column". Is there a way to
> > "alter table ... drop column"?
>
> SELECT without_a_column INTO xxx FROM tab;
> DROP TABLE tab;
> ALTER TABLE xxx RENAME TO tab;
>

Thanks. That worked.

-Tony

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mihai Gheorghiu 2000-05-30 20:36:03 PostgreSQL capabilities
Previous Message Thomas Good 2000-05-30 19:20:58 Re: Any way to send email from "within" PostgreSQL?