All columns of a base table have a default value

Copy SQL

WITH cols AS (SELECT c.table_schema, c.table_name, c.column_name,  coalesce(c.column_default, domain_default) AS default_value, c.ordinal_position
FROM information_schema.columns AS c LEFT JOIN information_schema.domains d USING (domain_schema, 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 t.table_type='BASE TABLE')
SELECT table_schema, table_name, Count(*) AS nr_of_columns, string_agg(column_name || '.' || default_value, ';<br>' ORDER BY ordinal_position) AS defaults
FROM cols
GROUP BY table_schema, table_name
HAVING Count(*)=Count(*) FILTER (WHERE default_value IS NOT NULL)
ORDER BY table_schema, table_name;