Alter column length

Поиск
Список
Период
Сортировка
Искать
От
Dan Wilson
Тема
Alter column length
Дата
Msg-id
000f01c0b3b6$513c25d0$543987cf@corp.peoplesoft.com
Список
Дерево обсуждения
Re: Alter column length "Brent R.Matzelle" <bmatzelle@yahoo.com>
I want to alter the length of a column without dumping an re-creating the
table.

I found this method in the archives and was just wondering if there are any
side effects...

-----------------------------
update pg_attribute set atttypmod = [column_oid] where attname =
'[column_name]' where attrelid = (select oid from pg_class where relname =
'[table_name]');
-----------------------------

Will doing this cause any problems?

-Dan


В списке pgsql-general по дате отправления
От: Stephan Szabo
Дата:
Сообщение: Re: Lost Trigger(s)?
От: Mihai Gheorghiu
Дата:
Сообщение: Migration from MSAccess
FAQ