WITH constraint_names AS (
select 
case when o.contype='p' then 'PRIMARY KEY'
when o.contype='u' then 'UNIQUE'
when o.contype='f' then 'FOREIGN KEY'
when o.contype='c' then 'TABLE CHECK'
when o.contype='x' then 'EXCLUDE'
when o.contype='t' then 'CONSTRAINT TRIGGER' END AS constraint_type,
(select nspname from pg_namespace where oid=o.connamespace) as table_schema,
c.relname AS table_name,
o.conname AS constraint_name
from pg_constraint o inner join pg_class c on c.oid = o.conrelid
where o.contype in ('p','u','c','f','x')
and conislocal=true)

SELECT constraint_type, table_schema, table_name, constraint_name
FROM constraint_names
WHERE constraint_name NOT ILIKE  '%' || table_name || '%'
AND translate(constraint_name,'_','') NOT ILIKE  '%' || translate(table_name,'_','') || '%'
ORDER BY constraint_type, table_schema, table_name;