Re: Alter table - Mailing list pgsql-sql

From Tomasz Myrta
Subject Re: Alter table
Date
Msg-id 3DCB7956.5040309@klaster.net
Whole thread Raw
In response to Alter table  ("Rachel.Vaudron" <rachel@lazaret.unice.fr>)
Responses Re: Alter table  ("Rachel.Vaudron" <rachel@lazaret.unice.fr>)
List 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



pgsql-sql by date:

Previous
From: Christoph Haller
Date:
Subject: Re: how to get the source table & field name of a view field
Next
From: "Rachel.Vaudron"
Date:
Subject: Re: Alter table