QUERY_PGSQL

Deprecated version

This document refers to a deprecated version of the RQL programming language.

Please go here for documentation related to the latest supported version.

Queries the PostgreSQL database directly using PostgreSQL's SQL syntax.

Syntax

QUERY_PGSQL[<type>](database, query,
                  cache := <default interval>,
                  retries := <default int>, retry_interval := <default interval>)

The database argument corresponds to the database name registered in the "Credentials Service".

Example

QUERY_PGSQL("db01", "SELECT a, b, c FROM table1")