Re: type of a field

Hi

1 u will have to use alter table to change the tables name RTFM
2 then create the new table with the changed columns
3 then insert into <newtable> values (select oldcolumn as newcolumn, ect...
from <renamedtable>);

but i did not read u'r question correctly.

i would do steps 1 and 2 above and then write a function in php
that

select * from <renamed table>

and

insert into <newtable>

-----Original Message-----
From: ameen eetemadi [mailto:ameen78101(at)yahoo(dot)com]
Sent: Tuesday, May 07, 2002 3:01 PM
To: pgsql-php(at)postgresql(dot)org
Subject: [PHP] type of a field

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