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