PostgreSQL Nodes

PostgreSQL is a production-grade relational database with advanced features. MaestroHub provides seamless integration for queries, inserts, updates, and complex transactions using connector nodes.

Configuration Quick Reference

Field	What you choose	Details
Parameters	Connection, Function, Function Parameters, Timeout Override	Select the connection profile, function, configure function parameters with expression support, and optionally override timeout.
Settings	Description, Timeout (seconds), Retry on Timeout, Retry on Fail, On Error	Node description, maximum execution time, retry behavior on timeout or failure, and error handling strategy. All execution settings default to pipeline-level values.

PostgreSQL Query Node

PostgreSQL Query Node

Execute SQL queries with full parameter binding for security.

Supported Function Types:

Function Name	Purpose	Common Use Cases
Execute Query	Run parameterized SQL against PostgreSQL	Reporting dashboards, ETL batches, transactional updates