About changing type af a column

Поиск
Список
Период
Сортировка
От Marc Soler
Тема About changing type af a column
Дата
Msg-id 03b401c2f37b$97512640$0300a8c0@terra
обсуждение исходный текст
Ответы Re: About changing type af a column  ("Victor Yegorov" <viy@pirmabanka.lv>)
Re: About changing type af a column  ("A.Bhuvaneswaran" <bhuvansql@myrealbox.com>)
Список pgsql-admin
Hi all,

I need to change a column length.

From varchar(150) to varchar(250).

It's easy to change with an ALTER command? Or I need to create a new column,
copy all data from the old column to the new one, then drop the old and
rename the new.

If only exists the second solutions, the new column it will be created last
one of the columns, then I must change all INSERT and UPDATE commands in my
application.
It's possible to create a column in a given position in the columns
structure of a table?.

Thanks in advance.

--
Marc Soler


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

Предыдущее
От: Daniel Rubio
Дата:
Сообщение: Re: Can't connect to my postgresql
Следующее
От: "Victor Yegorov"
Дата:
Сообщение: Re: About changing type af a column