Changed a column type from "integer" to varchar

Поиск
Список
Период
Сортировка
От Ying Lu
Тема Changed a column type from "integer" to varchar
Дата
Msg-id 41475129.1060108@cs.concordia.ca
обсуждение
Ответы Re: Changed a column type from "integer" to varchar
Re: Changed a column type from "integer" to varchar
Список 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,



В списке pgsql-general по дате отправления: