Actions7
- Check Actions
- Metadata Actions
Metadata → List Schemas
AI-generatedSummary
Query all schemas in the connected PostgreSQL database and return their names ordered alphabetically.
Inputs
None.
Output shape
a list of items where each item has a 'schemaName' field containing the name of a schema in the database.
If the query succeeds, the node outputs one item per schema found. If the query fails and 'Continue On Fail' is enabled, a single item with an 'error' field is output instead; otherwise, the node throws an error. The operation uses the credentials from the node's configured Postgres connection and does not require any additional parameters.
Examples
Example 1: List all database schemas
Use the 'List Schemas' operation under the 'Metadata' resource without additional parameters; the node returns all schema names as individual output items.