| Extracted from Pike v7.8 release 866 at 2018-07-18.

[Top]
Sql
Sql.postgres

# Method Sql.postgres()->big_query()

Method big_query

  `int|object big_query(object|string q, mapping(string|int:mixed)|void bindings)`

Description

  This is the only provided interface which allows you to query the database. If you wish to use the simpler "query" function, you need to use the Sql.Sql generic SQL-object.

  It returns a postgres_result object (which conforms to the Sql.sql_result standard interface for accessing data). I recommend using query() for simpler queries (because it is easier to handle, but stores all the result in memory), and big_query() for queries you expect to return huge amounts of data (it's harder to handle, but fetches results on demand).

Note

  This function can raise exceptions.

See also

  Sql.Sql , Sql.sql_result