Re: Changing the type of a column ?

From: Richard Bayet <bayet(at)enseirb(dot)fr>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Changing the type of a column ?
Date: 2001-03-01 05:55:05
Message-ID: 3A9DE439.A54D25DC@enseirb.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Thanks, I finally found that ALTER TABLE didn't permit any kind of type
change...

Grant a écrit :

> > 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

Browse pgsql-admin by date

  From Date Subject
Next Message Ene Cosmin 2001-03-01 09:17:06 DBI
Previous Message Grant 2001-03-01 05:38:10 Re: Changing the type of a column ?