Re: Change attribute of a column

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

In response to

Browse pgsql-sql by date

  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