begin;

create domain dtitle_new as varchar;

update pg_catalog.pg_type
set
	typoutput=new_type.typoutput,
	typsend=new_type.typsend,
	typbasetype=new_type.typbasetype,
	typtypmod=new_type.typtypmod
from pg_catalog.pg_type as new_type
where pg_catalog.pg_type.typname = 'dtitle'
and new_type.typname = 'dtitle_new';

CREATE OR REPLACE FUNCTION update_dtitle()
  RETURNS void AS
$BODY$
declare
	rec record;
	sql text;
begin
	for rec in
		select
			quote_ident(table_schema) as table_schema,
			quote_ident(table_name) as table_name,
			array_to_string(
				array_accum(column_name || '=trim(' || column_name || ')'),
				', '
			) as set_fields
		from (
			select
				t.table_schema,
				t.table_name,
				quote_ident(c.column_name) as column_name
			from information_schema.tables t
			join information_schema.columns c using (table_catalog, table_schema, table_name)
			where t.table_type='BASE TABLE'
			and c.domain_name = 'dtitle'
		) q
		group by table_schema, table_name
		order by table_schema, table_name
	loop
		sql := 'update ' || rec.table_schema || '.' || rec.table_name || ' set ' || rec.set_fields || ';';
		raise notice '%', sql;
		execute sql;
	end loop;
	return;
end;
$BODY$
  LANGUAGE 'plpgsql' VOLATILE;

drop domain dtitle_new;
drop FUNCTION update_dtitle();

commit;