Is there a method to do this without transversing the whole 20GB table?
What about manipulating the pg_attribute table and changing atttypid justlike we can manipulate atttypmod to change from varchar(4) to varchar(8)?
Thanks