Re: Alter table - Mailing list pgsql-sql

From Rachel.Vaudron
Subject Re: Alter table
Date
Msg-id Pine.LNX.4.33.0211080942530.12232-100000@lazaret.unice.fr
Whole thread Raw
In response to Re: Alter table  (Tomasz Myrta <jasiek@klaster.net>)
List pgsql-sql
Thanks a lot, but it's already what i am doing!
It's very a pity that there is no way do to this more quickly!!!

> alter table xxx rename to temp;
> create table xxx as
>   select field1, field2, ...without some field... from temp;
> drop table temp;
>
> Tomasz Myrta
>
>
Rachel



pgsql-sql by date:

Previous
From: Tomasz Myrta
Date:
Subject: Re: Alter table
Next
From: Christoph Haller
Date:
Subject: Re: PLpgSQL FOR IN EXECUTE question