Columns with exact/floating numeric types have textual default values

Copy SQL

SELECT A.table_schema, T.table_type, A.table_name , A.column_name, A.data_type, d.domain_default, a.column_default
FROM information_schema.columns A INNER JOIN information_schema.tables T USING (table_schema, table_name)
INNER JOIN information_schema.schemata S ON A.table_schema=S.schema_name
LEFT JOIN information_schema.domains D USING (domain_schema, domain_name)
WHERE (A.table_schema = 'public'
OR S.schema_owner<>'postgres')
AND A.data_type IN ('smallint','integer','bigint','double precision','real','numeric') AND
((D.domain_default LIKE '%::'|| A.data_type AND D.domain_default~'['']') 
OR (A.column_default LIKE '%::'|| A.data_type AND A.column_default~'['']'))
ORDER BY table_type, table_schema, table_name, column_name;