All domain default values

Copy SQL

SELECT domain_schema, domain_name , domain_default, string_agg(table_schema || '.' || table_name || '.' || column_name, ';<br>' ORDER BY table_schema, table_name) AS columns
FROM information_schema.columns c
RIGHT JOIN information_schema.domains d USING (domain_schema, domain_name)
INNER JOIN information_schema.schemata s
ON d.domain_schema=s.schema_name
WHERE  d.domain_default IS NOT NULL
AND (d.domain_schema = 'public'
OR s.schema_owner<>'postgres')
GROUP BY domain_schema, domain_name , domain_default
ORDER BY domain_schema, domain_name;