with simple_keys as (select 
(select nspname from pg_namespace where oid=c.relnamespace) as table_schema,
c.relname as table_name, 
(SELECT a.attname FROM pg_attribute a WHERE a.attrelid = c.oid AND a.attnum = o.conkey[1] AND a.attisdropped = FALSE)  AS column_name
from pg_constraint o inner join pg_class c on c.oid = o.conrelid
where o.contype='p' 
and c.relkind = 'r' 
and cardinality(o.conkey)=1),

tables_with_keys AS (select 
(select nspname from pg_namespace where oid=c.relnamespace) as table_schema,
c.relname as table_name 
from pg_constraint o inner join pg_class c on c.oid = o.conrelid
where o.contype='u'
and c.relkind = 'r')

SELECT sk.table_schema, sk.table_name
FROM simple_keys AS sk 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 sk.table_schema=s.schema_name
WHERE (coalesce (c.column_default, d.domain_default) ILIKE '%nextval%'  OR C.is_identity='YES')
AND (sk.table_schema = 'public' OR S.schema_owner<>'postgres')
AND Upper(sk.column_name)='ID'
AND c.data_type IN ('smallint','integer', 'bigint')
AND NOT EXISTS (SELECT * 
FROM tables_with_keys AS twk
WHERE twk.table_schema=sk.table_schema
AND twk.table_name=sk.table_name)
ORDER BY sk.table_schema, sk.table_name;