"Nick Fankhauser" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
