PostgreSQL Connection
Connect to a PostgreSQL database server to use PostgreSQL Query, Insert, Update, and Delete nodes in your workflows.
Configuration
| Field | Description | Required |
|---|---|---|
| Host | PostgreSQL server hostname or IP address | Yes |
| Port | PostgreSQL port (default: 5432) | Yes |
| Database | Database name to connect to | Yes |
| Username | PostgreSQL user | Yes |
| Password | PostgreSQL password | Yes |
Usage
Once created, this connection becomes available in all PostgreSQL nodes:
- PostgreSQL Query
- PostgreSQL Insert
- PostgreSQL Update
- PostgreSQL Delete
TIP
Ensure the PostgreSQL user has appropriate privileges (SELECT, INSERT, UPDATE, DELETE) on the target tables.