WITH defaults AS (SELECT c.table_schema, t.table_type, c.table_name, c.column_name, CASE WHEN column_default IS NOT NULL THEN 'COLUMN' ELSE 'DOMAIN' END AS object_type,  c.data_type, c.character_maximum_length, coalesce(c.column_default, domain_default) AS def_value
FROM information_schema.columns AS c LEFT JOIN information_schema.domains d ON c.domain_schema=d.domain_schema AND c.domain_name=d.domain_name
INNER JOIN INFORMATION_SCHEMA.tables AS t USING (table_schema, table_name)
WHERE
c.table_schema NOT IN (SELECT schema_name
FROM INFORMATION_SCHEMA.schemata
WHERE schema_name<>'public' AND
schema_owner='postgres' AND schema_name IS NOT NULL) 
AND c.data_type='character' 
AND coalesce(c.column_default, domain_default) LIKE '%::bpchar'
AND (column_default IS NOT NULL OR domain_default IS NOT NULL)
ORDER BY c.table_schema, c.table_name, c.ordinal_position)
SELECT table_schema, table_type, table_name, column_name, character_maximum_length, data_type, def_value, object_type
FROM defaults
WHERE char_length(trim(substring(def_value,'[''][^'']*['']'),'''')) <character_maximum_length
ORDER BY table_type, table_schema, table_name;