List partitions
pg_list_partitionsShows a partitioned table's partitions as a tree with bounds, keys, row/size estimates, and strategy; lists inheritance children with CHECK constraints on PostgreSQL 9.6.
Instructions
Show the partitions of a partitioned table as a tree: each partition with its bounds (FOR VALUES ..., DEFAULT), its own partition key when it is partitioned again, estimated rows and size on disk, plus the partitioning strategy (range, list, hash) and key.
On PostgreSQL 9.6, which has no declarative partitioning, it shows the table inheritance children and their CHECK constraints instead. A table without partitions or children answers with an empty list.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"table": "<table>"
},
"name": "pg_list_partitions"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | ||
| connection | No |