Re: Changing the type of a column in an already populated database.

Поиск
Список
Период
Сортировка
От Brian Minton
Тема Re: Changing the type of a column in an already populated database.
Дата
Msg-id arkcpe$2g59$2@news.hub.org
обсуждение исходный текст
Ответ на Changing the type of a column in an already populated database.  (David Pradier <dpradier@apartia.fr>)
Ответы Re: Changing the type of a column in an already populated  (Tino Wildenhain <tino@wildenhain.de>)
Re: Changing the type of a column in an already populated  ("scott.marlowe" <scott.marlowe@ihs.com>)
Список pgsql-general
David Pradier wrote:
> Hi!
>
> I'd like to know if it is possible to change the type of a column to a
> compatible one, in an already populated database.
> For example, changing a column from varchar(20) to varchar(25) ?
> I'm using postgresql 7.3rc1
>
> Thanks for your help.
>
> Best regards,
> David

dump the database, edit the dump file, and reload.  of course, this is
annonying on live data, but it works


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

Предыдущее
От: Brian Minton
Дата:
Сообщение: Re: Dumb Newbie Question - Mandrake 9.0 / PGSQL 7.2
Следующее
От: Savita
Дата:
Сообщение: Question about DEADLOCK