list_objects
List tables, views, materialized views, sequences, and foreign tables in a schema, with comments and approximate row counts. Filter by object type or name pattern.
Instructions
List tables, views, materialized views, sequences, and foreign tables in a schema, with comments and approximate row counts. Cheap. Filter by object_type and/or a SQL LIKE name_pattern (e.g. 'order%'). Prefer describe_object for the full shape of a single relation.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schema | Yes | ||
| object_type | No | ||
| name_pattern | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |