get_indexes
Retrieve indexes for a table, including access method, uniqueness, primary key status, ordered columns, and partial-index predicate.
Instructions
List indexes on a table: name, access method (btree/gin/gist/...), uniqueness, whether it backs the primary key, ordered columns with sort direction and NULLS ordering, and any partial-index predicate.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | Table name. | |
| schema | No | Schema name. Defaults to the server's default schema. |