Re: Is it safe to increase pg_attribute.atttypmod ? - Mailing list pgsql-admin

"Nick Fankhauser" <nickf@ontko.com> writes:
> The update to change a varchar(10) field to varchar(40) looked like this:

> update pg_attribute set atttypmod = 44
> where attrelid = ( select oid from pg_class where relname = 'test' )
> and attname = 'oldtest' ;

> Is this a smart thing to do?

Yup, that's the standard hack.

            regards, tom lane