Friday, October 15, 2010

Change field/column size in postgresql

Size will be value -4, so add 4 to whatever number you want.

update pg_attribute
set atttypmod = 2048
where attrelid = (
select oid
from pg_class
where relname = 'av_payment_transaction' )
and attname = 'solomonstatusmessage';

thanks to

Sunday, October 3, 2010