Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group