Re: Alter table

From: "Rachel(dot)Vaudron" <rachel(at)lazaret(dot)unice(dot)fr>
To: Tomasz Myrta <jasiek(at)klaster(dot)net>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Alter table
Date: 2002-11-08 08:50:24
Message-ID: Pine.LNX.4.33.0211080942530.12232-100000@lazaret.unice.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Christoph Haller 2002-11-08 09:06:10 Re: PLpgSQL FOR IN EXECUTE question
Previous Message Tomasz Myrta 2002-11-08 08:44:06 Re: Alter table