Re: How do I change column details

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: How do I change column details
Дата
Msg-id 20040310050539.GE31629@wolff.to
обсуждение исходный текст
Ответ на How do I change column details  (Simon Windsor <simon.windsor@cornfield.org.uk>)
Список pgsql-general
On Wed, Mar 10, 2004 at 00:42:18 +0000,
  Simon Windsor <simon.windsor@cornfield.org.uk> wrote:
> Hi
>
> I have a MySQL application which I am porting to Postgres. I have been
> asked to increase the size of a varchar column from 200 chars to 2000.
>
> Normally, in MySQL/Oracle this is done with the alter table modify
> column command.
>
> How do I do this in Postgres?
>
> I have just renamed the column, created the new one, copied the data
> into it and dropped the renamed column. Is the only way?

For varchar there is a way to do this by munging the system catalogs.
The method has been described on the list previously and should be in the
archives.

You might consider changing the column type to TEXT so that you don't
have to go through this again. If you really need it limited to keep
the app from barfing, use a constraint. That will be much easier to
update in the future.

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

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: Question on Opteron performance
Следующее
От: Tom Lane
Дата:
Сообщение: Re: does this look more like a possible bug or more like a possible hardware problem...? (long)