pg_indexes
   The view pg_indexes provides access to
   useful information about each index in the database.
  
Table 48.79. pg_indexes Columns
Column Type Description  | 
|---|
        Name of schema containing table and index  | 
        Name of table the index is for  | 
        Name of index  | 
        Name of tablespace containing index (null if default for database)  | 
        
       Index definition (a reconstructed   |