Re: Changing the size of a varchar field

Eric Ridge <ebr@tcdi.com> writes:
> Using PG 7.3.x, how stupid is this:
>     UPDATE pg_attribute SET atttypmod=<new size + 4> WHERE ....;

It'll work okay for a varchar column (not char) at least as far as the
table itself is concerned.  I think there are some issues for views
referencing the column, possibly also indexes.

            regards, tom lane