Re: Alter table

From: Tomasz Myrta <jasiek(at)klaster(dot)net>
To: "Rachel(dot)Vaudron" <rachel(at)lazaret(dot)unice(dot)fr>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Alter table
Date: 2002-11-08 08:44:06
Message-ID: 3DCB7956.5040309@klaster.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Uz.ytkownik Rachel.Vaudron napisa?:
> Hi,
>
> I wonder if it is possible to remove a field of a table ?
> I haven't found anything about this into the reference manual.
> Can I do something like that ?:
>
> ALTER TABLE table
> DROP COLUMN column;
alter table xxx rename to temp;
create table xxx as
select field1, field2, ...without some field... from temp;
drop table temp;

Tomasz Myrta

In response to

  • Alter table at 2002-11-08 07:22:55 from Rachel.Vaudron

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Rachel.Vaudron 2002-11-08 08:50:24 Re: Alter table
Previous Message Christoph Haller 2002-11-08 08:22:10 Re: how to get the source table & field name of a view field