Postgres Pro
Downloads
Home   >   mailing lists

Re: Quick way to alter a column type? - Mailing list pgsql-general

From Eric Bangug
Subject Re: Quick way to alter a column type?
Date
Msg-id 59a954c20807062241w50987925k55af733db027e587@mail.gmail.com
Whole thread Raw
In response to Quick way to alter a column type?  (Ow Mun Heng <Ow.Mun.Heng@wdc.com>)
Responses Re: Quick way to alter a column type?
List pgsql-general
Tree view
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.

ALTER TABLE tablename ALTER COLUMN columnname TYPE VARCHAR(5);


HTH.

-
Eric

pgsql-general by date:

Previous
From: Ow Mun Heng
Date:
Subject: Quick way to alter a column type?
Next
From: Scott Frankel
Date:
Subject: Re: roll back to 8.1 for PyQt driver work-around