Postgres Extended icon

Postgres Extended

Extended Postgres operations to complement the built-in Postgres node

Actions7

Metadata → List Tables

AI-generated

Summary

Retrieve a list of all tables of type 'BASE TABLE' within a specified database schema.

Inputs

  • Schema (required) — The schema containing the tables to list. Can be selected from a list of schemas or specified by name.

Output shape

a list of items, each containing the properties 'tableName' and 'schemaName' representing available tables in the specified schema.

Returns all base tables in the given schema sorted by table name. On failure, returns an error message if 'continueOnFail' is enabled; otherwise, throws an error.

Examples

Example 1: List all tables in the 'public' schema

Set 'resource' to 'Metadata', 'operation' to 'List Tables', and 'Schema' to 'public'.

Links

Discussion