WITH index_names AS (
SELECT 
  n.nspname AS table_schema,
  c2.relname AS table_name,
  c.relname AS index_name,
  i.indisunique AS is_unique
FROM 
  pg_catalog.pg_class AS c INNER JOIN pg_catalog.pg_index AS i ON i.indexrelid = c.oid
  INNER JOIN pg_catalog.pg_class AS c2  ON i.indrelid = c2.oid
  INNER JOIN pg_catalog.pg_namespace AS n ON c.relnamespace = n.oid
  INNER JOIN pg_catalog.pg_authid AS u ON  n.nspowner = u.oid
  INNER JOIN pg_catalog.pg_attribute AS a ON a.attrelid = c.oid    
WHERE c.relkind = 'i'
AND a.attnum>=1
AND a.attisdropped = FALSE
AND (n.nspname = 'public'
	 OR u.rolname <> 'postgres')
AND NOT EXISTS (SELECT * FROM pg_catalog.pg_constraint AS o WHERE o.conindid=i.indexrelid AND o.contype IN ('u','p')))
SELECT table_schema, table_name, index_name, is_unique
FROM index_names
WHERE index_name NOT ILIKE  '%' || table_name || '%'
AND translate(index_name,'_','') NOT ILIKE  '%' || translate(table_name,'_','') || '%'
ORDER BY is_unique DESC, table_schema, table_name;