PostgreSQL Component

Query and manage data in a PostgreSQL database

Component key: postgres

Description

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

This component returns data as an object that can be used in subsequent steps. Instead of generating dynamic queries and sanitizing SQL yourself, you can use generic queries with named parameter placeholders like ${variableKey}. For example, you can enter a query that reads INSERT INTO users (name, email) VALUES (${name}, ${email}). Then, you can enter values with keys of name and email, and whatever values you like. Values provided for name and email are sanitized automatically.

PostgreSQL Connections

PostgreSQL Connection

Create a new PostgreSQL connection and enter the host, port, and database for your PostgreSQL server. The username and password are optional inputs that can be put directly into a PostgreSQL connection.

Input	Default	Notes	Example
Input Database string / Required database	Default	Notes The database in PostgreSQL	Example admin
Input Host string / Required host	Default 192.168.0.1	Notes Provide the string value for the host of the server.	Example
Input Password string password	Default	Notes	Example
Input Port string / Required port	Default	Notes The port of the PostgreSQL server.	Example
Input Username string username	Default	Notes	Example

Actions

Query

Performs a query on a PostgreSQL database. | key: query

Input	Notes	Example
Input Optional Parameters data Key Value List params	Notes Optional parameters to insert into a query.	Example
Input Connection connection / Required postgresConnection	Notes	Example
Input Query Field string / Required queryField	Notes The query to be executed	Example INSERT INTO users(first_name, last_name, age) VALUES(${name.first}, ${name.last}, ${age})

---