Describe table
describe_tableInspect a PostgreSQL table’s columns, primary and foreign keys, constraints, and indexes to understand its schema before writing queries.
Instructions
Columns (type, nullability, default, comment), primary key, foreign keys, unique and check constraints, and indexes of one table.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | "table" or "schema.table" |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| kind | Yes | ||
| name | Yes | ||
| schema | Yes | ||
| columns | Yes | ||
| comment | Yes | ||
| indexes | Yes | ||
| totalSize | Yes | ||
| primaryKey | Yes | ||
| foreignKeys | Yes | ||
| estimatedRows | Yes | ||
| checkConstraints | Yes | ||
| uniqueConstraints | Yes |