| Lists: | pgsql-php |
|---|
| From: | "Duncan Adams (DNS)" <duncan(dot)adams(at)vcontractor(dot)co(dot)za> |
|---|---|
| To: | pgsql-php(at)postgresql(dot)org |
| Subject: | Re: type of a field |
| Date: | 2002-05-07 15:09:27 |
| Message-ID: | 7DD34E6DF5CD1B4283DDAB96A855DCED2F32C5@vodabemail1.vodacom.co.za |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-php |
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?