Thread: changing datatype from int to bigint quickly

changing datatype from int to bigint quickly

From
"Ow Mun Heng"
Date:
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