Short answer: You can't
Long answer: There are many workarounds.
Workaround 1:
dump the table with pg_dump dbase -t tablename
edit dump file to change table definition
drop and reload table.
Workaround 2:
Let's say you wanna change a varchar to a text type.
Original table t1:
col | type
----------
nam | varchar(32)
id | int4
select nam::text, id into t2 from t1;
drop table t1;
alter table t2 rename to t1;
You can do the above in a transaction if you are on a live database. I'd
back up the data first just to be sure.
On Tue, 7 May 2002, ameen eetemadi wrote:
> I want to change the type of a field in postgres .
> How can I do it ?
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Health - your guide to health and wellness
> http://health.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>