Base tables that have only the surrogate key and do not have any other column

Copy SQL

WITH tables_with_a_surrogate AS (SELECT table_schema, table_name 
FROM ((information_schema.table_constraints tc
INNER JOIN information_schema.constraint_column_usage cu
USING (table_schema, table_name, constraint_name))
INNER JOIN information_schema.columns c
USING (table_schema, table_name, column_name))
LEFT JOIN information_schema.domains d USING (domain_schema, domain_name)
INNER JOIN information_schema.schemata s
ON tc.table_schema=s.schema_name
WHERE tc.constraint_type IN ('PRIMARY KEY','UNIQUE') AND
(coalesce (c.column_default, d.domain_default) ILIKE '%nextval%'  OR C.is_identity='YES')
AND (tc.table_schema = 'public'
OR S.schema_owner<>'postgres'))
SELECT table_schema, table_name 
FROM tables_with_a_surrogate AS tws
WHERE  (SELECT Count(*) AS cnt FROM information_schema.columns AS c WHERE c.table_schema=tws.table_schema AND c.table_name=tws.table_name)=1
ORDER BY table_schema, table_name ;