51.72. pg_indexes
The view
pg_indexes
provides access to
useful information about each index in the database.
Table 51.73.
pg_indexes
Columns
| Name | Type | References | Description |
|---|---|---|---|
schemaname
|
name
|
|
Name of schema containing table and index |
tablename
|
name
|
|
Name of table the index is for |
indexname
|
name
|
|
Name of index |
tablespace
|
name
|
|
Name of tablespace containing index (null if default for database) |
indexdef
|
text
|
Index definition (a reconstructed
CREATE INDEX
command)
|