Postgres
Connect natively to your Postgres clusters to manage relational data. Execute complex analytical queries, trigger stored procedures, or sync data directly to data warehouses.
What can you do with Postgres?
Advanced Postgres Features
Leverage the full power of PostgreSQL. Execute complex CTEs, analytical window functions, and JSONB data manipulation directly from your workflows.
Secure Parameter Binding
Safely bind dynamic variables using standardized placeholders, protecting your production clusters from SQL injection while syncing data.
Enterprise Reliability
Engineered with Golang's robust standard database libraries, providing high-availability TCP pooling and instantaneous query execution.
Detailed Usage & Configuration
The Postgres node provides native, high-performance connectivity to your PostgreSQL clusters, acting as a crucial component for bi-directional data synchronization and ETL pipelines.
1. Query Execution
Similar to the MySQL node, you must enforce Parameter Binding for security.
INSERT INTO leads (email, source, metadata) VALUES (?, ?, ?);Add your dynamic parameters (like {{ $json.email }}) sequentially in the Query Parameters list. Because nLink operates on the advanced GORM driver layer under the hood, the ? placeholder is universally supported and automatically converted into Postgres' native $1, $2 format.
2. Auto-Parsing JSONB
PostgreSQL is famous for its JSONB column support. When the node queries a JSONB column, it will be returned as highly structured raw data that you can easily format or access using the nLink Code node or Set node downstream.
RETURNING keyword. Always append RETURNING id to your INSERT statements to instantly map the newly generated Database ID directly into your next workflow node!