List Views in Schema
pg_list_viewsList all views and materialized views in a PostgreSQL schema, with optional SQL definitions.
Instructions
List all views and materialized views in a PostgreSQL schema, including their definitions.
Args:
schema: Schema name (default: public)
include_definition: Include the SQL definition of each view (default: false)
response_format: Output format
Returns: JSON: { views: ViewInfo[], count: number, schema: string } Markdown: formatted table
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schema | No | PostgreSQL schema name (default: public) | public |
| include_definition | No | Include SQL view definition | |
| response_format | No | Output format: 'markdown' for human-readable, 'json' for machine-readable | markdown |