Note on third‑party tools
We aim to provide accurate and helpful details about third‑party tools, but we can’t guarantee that this information is always complete or up to date. If you notice any discrepancies, feel free to share them in the feedback section below. For the most reliable information, please always refer to the third‑party tool’s official documentation.
PostgreSQL is a popular relational database system.
This component allows you to query a PostgreSQL database.
Connections
On-Premise Connection
Authenticate requests to a PostgreSQL server.
Create a new PostgreSQL connection and enter the connection details for the PostgreSQL server.
Configure the Connection
- 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 |
Triggers
New and Updated Records
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 |
Actions
Query
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. |