A PostgreSQL database cluster contains one or more named databases. Users and groups of users are shared across the entire cluster, but no

This section describes several specialized constructs for making multiple comparisons between groups of values. These forms are syntactically related to the subquery forms

Another useful tool for monitoring database activity is the pg_locks system table. It allows the database administrator to view information

In an index scan, the index access method is responsible for regurgitating the TIDs of all the tuples it has been told about that match the scan keys

The catalog pg_amop stores information about operators associated with access method operator families. There is one row for each operator that

NameINSERT -- create new rows in a table Synopsis

PostgreSQL has many features not touched upon in this tutorial introduction, which has been oriented toward newer users of

Index access methods must handle concurrent updates of the index by multiple processes. The core PostgreSQL system obtains

NameSAVEPOINT -- define a new savepoint within the current transaction Synopsis

The catalog pg_authid contains information about database authorization identifiers (roles). A role subsumes the concepts of