Обсуждение: changing datatype from int to bigint quickly

Поиск
Список
Период
Сортировка

changing datatype from int to bigint quickly

От
"Ow Mun Heng"
Дата:
Is there a method to do this without transversing the whole 20GB table?

What about manipulating the pg_attribute table and changing atttypid just
like we can manipulate atttypmod to change from varchar(4) to varchar(8)?

Thanks