Postgres Pro
Downloads
Home   >   mailing lists

Re: Changed a column type from "integer" to varchar - Mailing list pgsql-general

From Greg Donald
Subject Re: Changed a column type from "integer" to varchar
Date
Msg-id ea9da26c040914135356f0b0ff@mail.gmail.com
Whole thread Raw
In response to Re: Changed a column type from "integer" to varchar  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: Changed a column type from "integer" to varchar  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Re: Changed a column type from "integer" to varchar  (Ying Lu <ying_lu@cs.concordia.ca>)
List pgsql-general
Tree view 
On Tue, 14 Sep 2004 13:33:32 -0700, Joshua D. Drake
<jd@commandprompt.com> wrote:
> You can not currently change the data type with alter table.

Are there any plans to add this functionality?

What's the best workaround?  Add a new column, copy data from old
column to new column, drop old column?


--
Greg Donald
http://destiney.com/

pgsql-general by date:

Previous
From: Arthur Hoogervorst
Date:
Subject: Re: Changed a column type from "integer" to varchar
Next
From: Tim
Date:
Subject: different results inside transactions