PostgreSQL List Tables

Lists all tables available in a specified PostgreSQL schema. Uses configured PostgreSQL credentials to query the database and returns a human-readable summary along with structured JSON of the results.

Usage

Use this node when you need to discover or verify the tables present in a particular PostgreSQL schema before building queries or data pipelines. Commonly placed early in workflows to explore database structure or to validate access and schema names.

Inputs

Field	Required	Type	Description	Example
credentials_path	True	STRING	Path or reference to the stored PostgreSQL credentials that the node will use to authenticate.
timeout	False	INT	Maximum time (in seconds) to wait for the list operation before failing.	30
schema	True	STRING	Target PostgreSQL schema from which to list tables.	public

Outputs

Field	Type	Description	Example
text	STRING	Readable summary of the tables found in the specified schema.	Tables in Schema: public - users - orders - products
json	STRING	JSON string containing structured results from the list operation.	{"data": [{"table_name": "users"}, {"table_name": "orders"}], "row_count": 2}
html	STRING	HTML representation of the results (may be empty when using default text output).	table_name users
xlsx	BYTES	Binary Excel data containing the results (may be empty when using default text output).
pdf	BYTES	Binary PDF data containing the results (may be empty when using default text output).

Important Notes

• Credentials required: You must supply a valid PostgreSQL credential reference via credentials_path.
• Schema value: The schema must exist and the provided user must have permission to access it.
• Timeouts: Large schemas or slow connections may require increasing the timeout to avoid premature failures.
• Output formats: The default operation returns text and JSON; HTML/XLSX/PDF fields may be empty unless explicitly produced by the underlying service.
• Service dependency: The node relies on a backend database service endpoint for execution.

Troubleshooting

• No tables returned: Verify the schema name and ensure the user has privileges to list tables in that schema.
• Authentication error: Check credentials_path points to a valid credential and that it contains correct host, port, database, username, and password.
• Timeout error: Increase the timeout input value, ensure network connectivity, and verify the database is responsive.
• Malformed JSON in output: Treat the json output as a string; parse it in a downstream step to access fields programmatically.
• Permission denied: Confirm the database user has USAGE/SELECT privileges on the target schema.