list_indexes
Retrieve and display indexes for a specific table or schema within a PostgreSQL database. Ideal for database exploration and optimizing query performance.
Instructions
List indexes for a table or schema
Input Schema
Name | Required | Description | Default |
---|---|---|---|
schema | Yes | ||
table | No |
Input Schema (JSON Schema)
{
"additionalProperties": false,
"properties": {
"schema": {
"maxLength": 63,
"minLength": 1,
"pattern": "^[a-zA-Z_][a-zA-Z0-9_]*$",
"type": "string"
},
"table": {
"maxLength": 63,
"minLength": 1,
"pattern": "^[a-zA-Z_][a-zA-Z0-9_]*$",
"type": "string"
}
},
"required": [
"schema"
],
"type": "object"
}