PostgreSQL Connector

PostgreSQL is a popular relational database system. This component allows you to query a PostgreSQL database.

Connections

Authenticate requests to a PostgreSQL server.

Create a new PostgreSQL connection and enter the connection details for the PostgreSQL server.

Enter the Host, the hostname or IP address of the PostgreSQL server (e.g., 192.168.0.1).
Enter the Port of the PostgreSQL server (default: 5432).
Enter the Database name to connect to.
Optionally enter a Username and Password to authenticate to the PostgreSQL server.
Set Require SSL to require an SSL connection to the PostgreSQL server.
Optionally set a Connection Timeout in milliseconds to wait before timing out (default: 5000).

Input	Comments	Default
Host	The hostname or IP address of the PostgreSQL server.
Port	The port of the PostgreSQL server.	5432
Database	The name of the database to connect to.
Username	The username used to authenticate to the PostgreSQL server.
Password	The password used to authenticate to the PostgreSQL server.
Require SSL	When true, requires an SSL connection to the PostgreSQL server.	false
Connection Timeout	The amount of time (in milliseconds) to wait for a connection to be established before timing out. Default is 5000ms.	5000

Checks for new and updated records in a table on a configured schedule.

Input	Comments	Default
Connection	The PostgreSQL connection to use.
Table Name	The name of the table to monitor for new and updated records.
Cursor Field	The column used to track new results. If the table has an auto incrementing integer ID, that ID can be used. If it has a 'created at' or 'updated at' timestamp, those can be used. Each time this trigger runs, it checks for records with values greater than the largest value from the last run.	updated_at
Cast Timestamps to Strings	When true, timestamp values are cast to strings to retain precision. PostgreSQL tracks microseconds, but JavaScript dates are measured in milliseconds, so precision can be lost when fetching TIME, TIMETZ, TIMESTAMP, and TIMESTAMPTZ fields. Enable this when the cursor field is a timestamp.	true

Performs a query on a PostgreSQL database.

Input	Comments	Default
Connection	The PostgreSQL connection to use.
Query Field	The SQL statement to execute against the database. Use named parameters (i.e. ${name}) or index variables (i.e. $1) to safely interpolate values.
Named Parameters	Optional named parameters to insert into a query.
Parameters Object or Array	Optional parameters to insert into a query. This should be a key-value object if you are using named inputs (i.e. ${name}), or an array if using index variables (i.e. $2) in your query. Values from this object will be merged with Named Parameters inputs if you are using named variables.