19.11.1. Statement Behavior search_path (string)

Aggregate functions compute a single result from a set of input values. The built-in normal aggregate functions are listed in Table 9-51 and Table

When you create complex database structures involving many tables with foreign key constraints, views, triggers, functions, etc. you implicitly create a net of dependencies

NameCREATE USER MAPPING -- define a new mapping of a user to a foreign server

The results of two queries can be combined using the set operations union, intersection, and difference. The syntax is

The SQL standard defines four levels of transaction isolation. The most strict is Serializable, which is defined by the standard in a paragraph

At all times, PostgreSQL maintains a write ahead log (WAL) in the pg_xlog/ subdirectory

The pg_enum catalog contains entries showing the values and labels for each enum type. The internal representation of a given enum value is

The BRIN interface has a high level of abstraction, requiring the access method implementer only to implement the semantics of the data type

NameUPDATE -- update rows of a table Synopsis