Describe PostgreSQL Table
pg_describe_tableRetrieve detailed table metadata including columns, data types, constraints, indexes, and foreign keys. Choose between JSON or Markdown output.
Instructions
Full description of a table: columns, data types, constraints, indexes, and foreign keys.
Args:
table: Table name (required)
schema: Schema name (default: public)
response_format: Output format
Returns: JSON: { table, schema, columns: ColumnInfo[], foreign_keys: ForeignKeyInfo[], check_constraints, indexes: IndexInfo[] } Markdown: multi-section formatted description
Errors:
"Table not found" if table/schema doesn't exist
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | Table name | |
| schema | No | PostgreSQL schema name (default: public) | public |
| response_format | No | Output format: 'markdown' for human-readable, 'json' for machine-readable | markdown |