Connections

PostgreSQL

Set up a PostgreSQL connection in the workspace for the database actions to use.

PostgreSQL

Connects a PostgreSQL database to the workspace. The PostgreSQL database actions in your robots use this connection.

Fields

Connection string

Enter the full connection string for the PostgreSQL database. It follows this shape:

postgresql://user:password@host:port/database

Example:

postgresql://admin:mypassword@192.168.0.1:5432/production

Part	What it is
user	The database user's name
password	That user's password
host	The server's IP address or name
port	The connection port (default: 5432)
database	The database's name

tip

The connection string usually comes from the database administrator, or from the PostgreSQL server's own settings.

Using it in the Designer

For a robot to use this connection, add the PostgreSQL - Connection action to the flow. In the action's settings, pick the connection saved in the workspace. Later PostgreSQL actions (query, insert, update and the rest) use it automatically.