describe_object
Inspect any database object's schema details—columns, keys, indexes, constraints, and row counts—to understand unfamiliar tables before writing queries.
Instructions
Describe one relation: columns (name, type, nullable, default, comment), primary key, foreign keys in both directions, indexes, check and unique constraints, and an approximate row count from pg_class.reltuples. Cheap. Prefer this over querying catalogs by hand; use it before writing queries against unfamiliar tables.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | Yes | ||
| schema | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||