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)
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
