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@xxxxxxxxx] Sent: Tuesday, May 07, 2002 3:01 PM To: pgsql-php@xxxxxxxxxxxxxx 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
