PostgreSQL

Configuration

Query (SELECT)

Operation

Query (SELECT)

Host*

localhost or your.database.host

Port*

5432

Database Name*

your_database

Username*

postgres

Password*

••••••••

SSL Mode

Select...

SQL Query*

sql

SELECT * FROM users WHERE active = true

Query (SELECT) (postgresql_query)

Execute a SELECT query on PostgreSQL database

Input

Parameter	Type	Required	Description
`host`	string	Yes	PostgreSQL server hostname or IP address
`port`	number	Yes	PostgreSQL server port (default: 5432)
`database`	string	Yes	Database name to connect to
`username`	string	Yes	Database username
`password`	string	Yes	Database password
`ssl`	string	No	SSL connection mode (disabled, required, preferred)
`query`	string	Yes	SQL SELECT query to execute

Output

Parameter	Type	Description
`message`	string	Operation status message
`rows`	array	Array of rows returned from the query

Insert Data

Operation

Insert Data

Host*

localhost or your.database.host

Port*

5432

Database Name*

your_database

Username*

postgres

Password*

••••••••

SSL Mode

Select...

Table Name*

users

Data (JSON)*

json

{\n "name": "John Doe",\n "email": "john@example.com",\n "active": true\n}

Insert Data (postgresql_insert)

Insert data into PostgreSQL database

Input

Parameter	Type	Required	Description
`host`	string	Yes	PostgreSQL server hostname or IP address
`port`	number	Yes	PostgreSQL server port (default: 5432)
`database`	string	Yes	Database name to connect to
`username`	string	Yes	Database username
`password`	string	Yes	Database password
`ssl`	string	No	SSL connection mode (disabled, required, preferred)
`table`	string	Yes	Table name to insert data into
`data`	object	Yes	Data object to insert (key-value pairs)

Output

Parameter	Type	Description
`message`	string	Operation status message
`rows`	array	Inserted data (if RETURNING clause used)

Update Data

Operation

Update Data

Host*

localhost or your.database.host

Port*

5432

Database Name*

your_database

Username*

postgres

Password*

••••••••

SSL Mode

Select...

Table Name*

users

Update Data (JSON)*

json

{\n "name": "Jane Doe",\n "email": "jane@example.com"\n}

WHERE Condition*

id = 1

Update Data (postgresql_update)

Update data in PostgreSQL database

Input

Parameter	Type	Required	Description
`host`	string	Yes	PostgreSQL server hostname or IP address
`port`	number	Yes	PostgreSQL server port (default: 5432)
`database`	string	Yes	Database name to connect to
`username`	string	Yes	Database username
`password`	string	Yes	Database password
`ssl`	string	No	SSL connection mode (disabled, required, preferred)
`table`	string	Yes	Table name to update data in
`data`	object	Yes	Data object with fields to update (key-value pairs)
`where`	string	Yes	WHERE clause condition (without WHERE keyword)

Output

Parameter	Type	Description
`message`	string	Operation status message
`rows`	array	Updated data (if RETURNING clause used)

Delete Data

Operation

Delete Data

Host*

localhost or your.database.host

Port*

5432

Database Name*

your_database

Username*

postgres

Password*

••••••••

SSL Mode

Select...

Table Name*

users

WHERE Condition*

id = 1

Delete Data (postgresql_delete)

Delete data from PostgreSQL database

Input

Parameter	Type	Required	Description
`host`	string	Yes	PostgreSQL server hostname or IP address
`port`	number	Yes	PostgreSQL server port (default: 5432)
`database`	string	Yes	Database name to connect to
`username`	string	Yes	Database username
`password`	string	Yes	Database password
`ssl`	string	No	SSL connection mode (disabled, required, preferred)
`table`	string	Yes	Table name to delete data from
`where`	string	Yes	WHERE clause condition (without WHERE keyword)

Output

Parameter	Type	Description
`message`	string	Operation status message
`rows`	array	Deleted data (if RETURNING clause used)

Execute Raw SQL

Operation

Execute Raw SQL

Host*

localhost or your.database.host

Port*

5432

Database Name*

your_database

Username*

postgres

Password*

••••••••

SSL Mode

Select...

SQL Query*

sql

SELECT * FROM table_name

Execute Raw SQL (postgresql_execute)

Execute raw SQL query on PostgreSQL database

Input

Parameter	Type	Required	Description
`host`	string	Yes	PostgreSQL server hostname or IP address
`port`	number	Yes	PostgreSQL server port (default: 5432)
`database`	string	Yes	Database name to connect to
`username`	string	Yes	Database username
`password`	string	Yes	Database password
`ssl`	string	No	SSL connection mode (disabled, required, preferred)
`query`	string	Yes	Raw SQL query to execute

Output

Parameter	Type	Description
`message`	string	Operation status message
`rows`	array	Array of rows returned from the query

Usage Instructions

Integrate PostgreSQL into the workflow. Can query, insert, update, delete, and execute raw SQL.

Notes

Category: tools
Type: postgresql

PostgreSQL

On this page