How to change column type in PostgreSQL 7.1.2

Поиск
Список
Период
Сортировка
От Vilson farias
Тема How to change column type in PostgreSQL 7.1.2
Дата
Msg-id 004b01c330e1$aff66040$98a0a8c0@dgtac
обсуждение исходный текст
Список pgsql-general
Greetings,

  I'm wondering if there is a way to change a column type in PostgreSQL
7.1.2 without reconstruction of table + pg_dump/restore of table data
(machine can't be stopped for a long time). I have a table with a integer
column and I would like to change it to varchar(20). One more thing, this
collumn belongs to a composed primary key. Is it possible?

Best regards

----------------------------------------------------------------------------
----
José Vilson de Mello de Farias
Software Engineer

Dígitro Tecnologia Ltda - www.digitro.com.br
APC - Customer Oriented Applications
E-mail: vilson.farias@digitro.com.br
Tel.: +55 48 281 7158
ICQ 11866179


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

Предыдущее
От: Justin Clift
Дата:
Сообщение: Re: [HACKERS] SAP and MySQL ... [and Benchmark]
Следующее
От: Martin Marques
Дата:
Сообщение: Re: Postgres performance comments from a MySQL user