pg_list_views
Retrieve all views and materialized views in a PostgreSQL schema with their full SQL definitions. Use this to inspect view bodies rather than just names.
Instructions
List views and materialized views in a schema with their SQL definitions. Use this over pg_list_tables with includeViews: true when you want the view body, not just names.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schema | No | Schema name (defaults to 'public'). | public |
| includeMaterialized | No | If true, include materialized views. |