Changing the type of a column ?

From: Bayet Richard <bayet(at)enseirb(dot)fr>
To: pgsql-admin(at)postgresql(dot)org
Subject: Changing the type of a column ?
Date: 2001-03-01 03:05:38
Message-ID: 3A9DBC82.7AA25674@enseirb.fr
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 ?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Grant 2001-03-01 05:38:10 Re: Changing the type of a column ?
Previous Message Grant 2001-03-01 01:26:59 Vacuum.