changing datatype from int to bigint quickly

From: "Ow Mun Heng" <ow(dot)mun(dot)heng(at)wdc(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: changing datatype from int to bigint quickly
Date: 2009-05-23 07:01:20
Message-ID: D1109E8B2FB53A45BDB60F8145905CE901FD3A07@wdmyexbe03.my.asia.wdc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2009-05-23 07:34:32 Re: Code tables, conditional foreign keys?
Previous Message Conrad Lender 2009-05-23 06:27:29 Re: Code tables, conditional foreign keys?