Too generic names (candidate key columns)

select target_schema as table_schema, target_table as table_name, a.attname as suspected_column_name, constraint_type
from (select 
(select nspname from pg_namespace where oid=m.relnamespace) as target_schema,
m.relname as target_table, 
m.oid as target_table_oid,
unnest(o.conkey) AS target_col,
CASE WHEN o.contype='p' THEN 'PRIMARY KEY'
WHEN o.contype='u' THEN 'UNIQUE' END AS constraint_type
from pg_constraint o inner join pg_class c on c.oid = o.conrelid
inner join pg_class m on m.oid = o.conrelid
where o.contype in ('u','p') and o.conrelid in (select oid from pg_class c where c.relkind = 'r')) t
inner join pg_attribute a on t.target_col = a.attnum and t.target_table_oid = a.attrelid and a.attisdropped = false
where a.attname~*'^[_]*(id|kood|identifikaator|identifier|code|number)[_]*$'
order by target_schema, target_table, attname;