From: | Volker Paul <vpaul(at)dohle(dot)com> |
---|---|
To: | Bernie Huang <bernie(dot)huang(at)ec(dot)gc(dot)ca> |
Cc: | PGSQL-SQL <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Change attribute of a column |
Date: | 2000-07-26 12:01:18 |
Message-ID: | 397ED30D.6FF6DA89@dohle.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(dot)huang(at)ec(dot)gc(dot)ca>
> Programmer
> Environment Canada
> Standards and Technology Services
>
> Bernie Huang
> Programmer <bernie(dot)huang(at)ec(dot)gc(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | pgsql-sql | 2000-07-26 14:11:15 | optimize sql |
Previous Message | Jerome Raupach | 2000-07-26 10:55:52 | Exec query |