Hi,

I have managed to change the length of a varchar field to 100 using:

update pg_attribute set atttypmod = 104 where attname = 'field_name' and
attrelid = (select oid from pg_class where relname = 'table_name');

I was wondering if I can do something similar to change the size of a
numeric field, e.g. from numeric(8,2) to numeric(10,2). I can't really see
how the data in pg_attribute for this field relates to the field size. Does
anyone know if this is possible & if so how?

Thanks very much,
Tamsin

(PostgreSQL 7.0.2)