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, optional Timeout	Select the shared PostgreSQL connection profile and configure SQL text, bound parameters, and execution timeouts.
Settings	Retry on Fail, On Error, Notes, Display Note In Pipeline	Control pipeline behavior with retry strategy, error handling, and inline operator notes.

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