Quick way to alter a column type?

From: Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Quick way to alter a column type?
Date: 2008-07-07 03:44:21
Message-ID: 1215402261.4952.10.camel@neuromancer.home.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is there any quick hacks to do this quickly? There's around 20-30million
rows of data.

I want to change a column type from varchar(4) to varchar(5) or should I
just use text instead.

Browse pgsql-general by date

  From Date Subject
Next Message Eric Bangug 2008-07-07 05:41:20 Re: Quick way to alter a column type?
Previous Message Kent Tong 2008-07-07 03:41:55 Re: postgresql's MVCC implementation