changing datatype from int to bigint quickly - Mailing list pgsql-general

From Ow Mun Heng
Subject changing datatype from int to bigint quickly
Date
Msg-id D1109E8B2FB53A45BDB60F8145905CE901FD3A07@wdmyexbe03.my.asia.wdc.com
Whole thread Raw
List pgsql-general
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

pgsql-general by date:

Previous
From: Conrad Lender
Date:
Subject: Re: Code tables, conditional foreign keys?
Next
From: Scott Marlowe
Date:
Subject: Re: Code tables, conditional foreign keys?