I would like to get a list of all UNIQUE indexes (for unique column combinations) for specific database in PostgreSQL. I searched but could not find the query for this.
I found these two queries.
SELECT indexname FROM pg_indexes; SELECT * from pg_indexes where schemaname = 'public';
but neither the one, suits my needs. I only need just those which identify indexes for unique columns. Thanks.