Resize varchar column - Mailing list pgsql-general

From John Sidney-Woollett
Subject Resize varchar column
Date
Msg-id 2590.192.168.0.64.1075905937.squirrel@mercury.wardbrook.com
Whole thread Raw
Responses Re: Resize varchar column
List pgsql-general
Is it possible to alter a table to resize a varchar column? The PG docs
indicate lots of uses for "alter table T alter column C..." but not one
that allows the changing of the type (or same type, new size).

This is possible in Oracle (provided you are increasing the column size).

Is there a way to resize the column without having to drop or recreate the
table or column?

Thanks

John Sidney-Woollett

pgsql-general by date:

Previous
From: Francois Suter
Date:
Subject: Re: Anyone has nls activated on Mac OS X?
Next
From: Bruno Wolff III
Date:
Subject: Re: Resize varchar column