The pg_visibility module provides a means for examining the visibility map (VM) and page-level visibility information. It also provides functions

The usual comparison operators are available, as shown in Table 9-1. Table 9-1. Comparison Operators

NameDROP AGGREGATE -- remove an aggregate function Synopsis

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

NameCREATE LANGUAGE -- define a new procedural language Synopsis

There are two kinds of indexes that can be used to speed up full text searches. Note that indexes are not mandatory for full text searching, but in cases where a column is

Table C-1 lists all tokens that are key words in the SQL standard and in PostgreSQL 9.6.0. Background information can be found in Section 4

NameDROP TABLE -- remove a table Synopsis

Among all relational operators the most difficult one to process and optimize is the join. The number of possible query plans grows exponentially with

This module implements a data type chkpass that is designed for storing encrypted passwords. Each password is automatically converted to encrypted