with simple_keys as (select 
n.nspname 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
inner join pg_namespace n on c.relnamespace=n.oid
where o.contype='p'
and  c.relkind = 'r' 
and cardinality(o.conkey)=1)
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')
ORDER BY sk.table_schema, sk.table_name;