WITH pk_columns AS (select target_table_oid, target_schema as table_schema, target_table as table_name, a.attname as column_name, a.attnum as ordinal_position
from (select 
nc.nspname as target_schema,
c.relname as target_table, 
c.oid as target_table_oid,
unnest(o.conkey) AS target_col
from pg_constraint o inner join pg_class c on c.oid = o.conrelid
inner join pg_namespace as nc on nc.oid=c.relnamespace
inner join  pg_authid AS a on nc.nspowner=a.oid
where (nc.nspname='public' or rolname<>'postgres')
and o.contype='p') t
inner join pg_attribute a on t.target_col = a.attnum and t.target_table_oid = a.attrelid and a.attisdropped = false),
non_pk_columns AS (SELECT table_schema, table_name, column_name, ordinal_position
FROM INFORMATION_SCHEMA.columns
EXCEPT SELECT table_schema, table_name, column_name, ordinal_position
FROM pk_columns)
SELECT table_schema, table_name, EXISTS (SELECT *
FROM pg_inherits pi WHERE pi.inhrelid=p.target_table_oid) AS has_parent, string_agg(column_name || '(' || ordinal_position::text || ')',',' ORDER BY ordinal_position) AS primary_key_columns
FROM pk_columns AS p
WHERE EXISTS (SELECT 1 FROM non_pk_columns AS n WHERE p.table_schema=n.table_schema AND p.table_name=n.table_name AND p.ordinal_position>n.ordinal_position)
GROUP BY table_schema, table_name, has_parent
ORDER BY has_parent, table_schema, table_name;