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@yahoo.com]
Sent: Tuesday, May 07, 2002 3:01 PM
To: pgsql-php@postgresql.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