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: (view raw, whole thread or download thread mbox)
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 ?


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-2017 The PostgreSQL Global Development Group