Hello,
I asked a similar question before and it seems there
is no way but using pg_dump.
Question to the developers:
Is it planned to make type changing (and casting) possible
with ALTER TABLE or the like?
Volker
Bernie Huang wrote:
>
> Hi,
>
> I have a field in text[] and I want to change it to a datetime[]. Is it
> possible? how? Thanks very much.
>
> - Bernie
>
> ------------------------------------------------------------------------
>
> Bernie Huang <bernie.huang@ec.gc.ca>
> Programmer
> Environment Canada
> Standards and Technology Services
>
> Bernie Huang
> Programmer <bernie.huang@ec.gc.ca>
> Environment Canada HTML Mail
> Standards and Technology Services
> 700-1200 West 73 Ave. Fax: (604)664-9195
> Vancouver Work: (604)664-9172
> BC Netscape Conference Address
> V6P 6H9 Netscape Conference DLS Server
> Canada
> Additional Information:
> Last Name Huang
> First Name Bernie
> Version 2.1