Re: Changed a column type from "integer" to varchar

On Tue, Sep 14, 2004 at 01:33:32PM -0700, Joshua D. Drake wrote:

> You can not currently change the data type with alter table.

... but you can add a new column with the desired type, UPDATE it with
the transformed data, and the DROP the old column.

> Ying Lu wrote:

> >I have a question about alter a column's type in a postgreSQL table.
> >
> >For example, I have 10, 000 records in a table name "test", I'd like to
> >change column "machineID" type from integer to varchar. I am looking for
> >something like:
> >
> >alter table test alter column machineID ... ... varchar

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Escucha y olvidarás; ve y recordarás; haz y entenderás" (Confucio)