Skip to main content

Postgres_Connection.read

readquerylimit

Group: Input

Documentation

Execute the query and load the results into memory as a Table.

Arguments

  • query: name of the table or sql statement to query. If supplied as Text it is treated as a table name.
  • limit: the maximum number of rows to read.

Remarks

Side Effects

Note that the read method is running without restrictions when the output context is disabled, but it can technically cause side effects, if it is provided with a DML query. Usually it is preferred to use execute_update for DML queries, or if they are supposed to return results, the read should be wrapped in an execution context check.