Postgres Extended icon

Postgres Extended

Extended Postgres operations to complement the built-in Postgres node

Actions7

Metadata → List Views

AI-generated

Summary

Retrieve and list all views within a specified PostgreSQL schema.

Inputs

  • Schema (required) — The schema to search for views, specified either by selecting from a list of schemas or by manually entering the schema name.

Output shape

a list of items, each with JSON containing the viewName and schemaName strings

Returns all views in the specified schema ordered by view name; paired input item is attached if input exists. On error, emits an error message JSON if 'continue on fail' is enabled, otherwise throws an error.

Examples

Example 1: List all views in the "public" schema

Set the 'Schema' parameter to 'public' mode from list or by name.

Links

Discussion