Domain usage in base tables

Copy SQL

SELECT domain_schema, domain_name, Count(*) AS number_of_usages, string_agg(table_schema || '.' || table_name || '.' || column_name, ';<br>' ORDER BY table_schema, table_name, column_name) AS columns
FROM Information_schema.column_domain_usage
WHERE domain_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 (table_schema, table_name) IN (SELECT table_schema, table_name 
FROM INFORMATION_SCHEMA.tables WHERE table_type='BASE TABLE')
GROUP BY domain_schema, domain_name
ORDER BY  count(*) DESC, domain_schema, domain_name;