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.