gp_table_indexes
The gp_toolkit.gp_table_indexes view shows the indexes that belong to each user-accessible table.
| Column | Description |
|---|---|
tireloid |
The object ID of the table that owns the index |
tiidxoid |
The object ID of the index on the table |
titableschemaname |
The name of the schema that contains the table |
titablename |
The name of the table |
tiindexschemaname |
The name of the schema that contains the index |
tiindexname |
The name of the index |