Re: Is there a way to drop a column?

From: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
To: "G(dot) Anthony Reina" <reina(at)nsi(dot)edu>
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 18:27:46
Message-ID: Pine.LNX.3.96.1000530202423.31890A-100000@ara.zf.jcu.cz
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-general


On Tue, 30 May 2000, G. Anthony Reina wrote:

> Somehow some columns from one of my tables "melded" with another table.
> I'm trying to figure out how this happened, but in the meantime, I'd
> like to be able to delete the extra columns in the table.
>
> 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;

OK?

Karel

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message G. Anthony Reina 2000-05-30 18:43:58 Is there a way to drop a column?
Previous Message Philip Hallstrom 2000-05-30 18:20:10 Any way to send email from "within" PostgreSQL?