The view pg_indexes provides access to useful information about each index in the database.
Table 43-31. pg_indexes Columns
|schemaname||name||pg_namespace.nspname||name of schema containing table and index|
|tablename||name||pg_class.relname||name of table the index is for|
|indexname||name||pg_class.relname||name of index|
|indexdef||text||index definition (a reconstructed creation command)|
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.