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

Hello,

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

J

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

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd(at)commandprompt(dot)com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL