The view pg_user_mappings provides access to information about user mappings. This is essentially a publicly readable view of

A database role can have a number of attributes that define its privileges and interact with the client authentication system.

Full Text Searching (or just text search) provides the capability to identify natural-language documents that satisfy a

The core PostgreSQL distribution includes the GiST operator classes shown in Table 61-1. (Some of the optional

An index can be defined on more than one column of a table. For example, if you have a table of this form:

Namepg_basebackup -- take a base backup of a PostgreSQL cluster

Each heap relation has a Visibility Map (VM) to keep track of which pages contain only tuples that are known to be visible to all active transactions; it also keeps track of

It is possible to control the query planner to some extent by using the explicit JOIN syntax. To see why this matters, we first need some background

This is a list of acronyms commonly used in the PostgreSQL documentation and in discussions about PostgreSQL

WAL is automatically enabled; no action is required from the administrator except ensuring that the disk-space requirements for the