Skip to main content
Docs
Go to the Studio
Roberty Studio
RPAPostgreSQL

PostgreSQL - Query

PostgreSQL - Query

Runs a SQL statement on a PostgreSQL database. It supports SELECT, INSERT, UPDATE, DELETE and other standard SQL statements. The results can be iterated with PostgreSQL: For each result or read directly from the action returns.


Options​

Connection​

Reference to the PostgreSQL: Connection action that will be used to run the query.

Query to be executed​

SQL statement to run, for example SELECT * FROM public.usuarios WHERE ativo = true.

Advanced options​

Query timeout​

Maximum time, in seconds, this query may run. When empty, the Default query timeout set on the PostgreSQL: Connection applies. A value of 0 means no limit. When the limit is reached, the action fails; the connection's Time limits section describes what happens to the query and the connection. Optional field.

Returns​

Javascript code​

js
actions["action-id"].query        // query that was executed (Text)
actions["action-id"].results      // query results (Any)
actions["action-id"].resultsCount // number of results (Number)

Field selection​

  • query — query that was executed (Text)
  • results — list of the query results (Any)
  • resultsCount — total count of the results (Number)

Rules and Conditions​

  • The Connection and Query fields are required.
  • results and resultsCount are relevant for SELECT statements.
  • The Query timeout field is optional and its value is in seconds; 0 means no limit.
  • When Query timeout is empty, the connection's default query timeout applies.