Changed a column type from "integer" to varchar

From: Ying Lu <ying_lu(at)cs(dot)concordia(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Changed a column type from "integer" to varchar
Date: 2004-09-14 20:14:33
Message-ID: 41475129.1060108@cs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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,

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2004-09-14 20:33:32 Re: Changed a column type from "integer" to varchar
Previous Message Jeffrey W. Baker 2004-09-14 18:11:38 Re: disk performance benchmarks