SELECT 
  n.nspname AS table_schema,
  c2.relname AS table_name,
  c.relname AS index_name
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
WHERE c.relkind = 'i'
AND i.indisunique=TRUE
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'))
AND (c.relname ~*'(andme(?!baas)|data(?!base)|info|veerg|column|kitsendus|piirang|constraint|restriction)'
OR (c.relname~*'^[^[:alpha:]]*(pk|uk|uq|ak|ck|chk|fk|excl|key|relationship|id|voti|seos|suhe)[^[:alpha:]]*$'))
ORDER BY table_schema, table_name, index_name;