NameCREATE RULE -- define a new rewrite rule Synopsis

NameMOVE -- position a cursor Synopsis

The task of the planner/optimizer is to create an optimal execution plan. A given SQL query (and hence, a query tree) can be actually executed in a

The functions described in this section are used to control and monitor a PostgreSQL installation.

19.7.1. Planner Method Configuration These configuration parameters provide a crude method of influencing the query plans chosen

Table 9-42 shows the operators that are available for use with the two JSON data types (see Section 8.14)

An alternative to the built-in standby mode described in the previous sections is to use a restore_command that polls the archive location. This

In addition to the system catalogs, PostgreSQL provides a number of built-in views. Some system views provide convenient access to some commonly

NameDO -- execute an anonymous code block Synopsis

The view pg_locks provides access to information about the locks held by active processes within the database server. See Chapter 13 for more