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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html