get-table-info
Retrieve comprehensive details about a PostgreSQL table, including columns, constraints, indexes, and optional statistics like row count and size, for efficient database analysis and management.
Instructions
Get detailed information about a specific table including columns, constraints, indexes, and optionally statistics like row count and size.
Input Schema
Name | Required | Description | Default |
---|---|---|---|
include_statistics | No | ||
schema_name | No | public | |
table | Yes |
Input Schema (JSON Schema)
{
"$schema": "http://json-schema.org/draft-07/schema#",
"additionalProperties": false,
"properties": {
"include_statistics": {
"default": true,
"type": "boolean"
},
"schema_name": {
"default": "public",
"type": "string"
},
"table": {
"minLength": 1,
"type": "string"
}
},
"required": [
"table"
],
"type": "object"
}