Re: Is there a way to drop a column? - Mailing list 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