PostgreSQL Show Indexes and IsUnique Flag in tables

gistfile1.txt

  select
       n.nspname			TableSchema,
  c.relname as				TableName,
  a.relname as 				IndexName,
    b.indisunique 			IsUnique

from
  pg_class a
    inner join
  pg_index b
    on
  a.oid = b.indexrelid
    inner join
  pg_class c
    on
  b.indrelid = c.oid
 
 
JOIN
	pg_catalog.pg_namespace n ON
    	n.oid        = a.relnamespace
where

  a.relname not like 'pg_%'