Re: Changing the type of a column ?

From: Grant <grant(at)conprojan(dot)com(dot)au>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Changing the type of a column ?
Date: 2001-03-01 05:38:10
Message-ID: Pine.LNX.4.21.0103011536580.4592-100000@webster.conprojan.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> Is it possible to directly change the type of a column (eg: from int4 to
> date) or does one have to first add a column of the desired type, copy
> the first column's content, then drop this first column ?

No it's not possible. Your solution is correct.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Richard Bayet 2001-03-01 05:55:05 Re: Changing the type of a column ?
Previous Message Bayet Richard 2001-03-01 03:05:38 Changing the type of a column ?