The index construction and maintenance functions that an index access method must provide in IndexAmRoutine are:

NameCREATE INDEX -- define a new index Synopsis

The view pg_timezone_abbrevs provides a list of time zone abbreviations that are currently recognized by the datetime input routines. The contents

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

The catalog pg_proc stores information about functions (or procedures). See

This module implements a data type ltree for representing labels of data stored in a hierarchical tree-like structure. Extensive facilities for searching

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

NameDROP TYPE -- remove a data type Synopsis

Thus far, our queries have only accessed one table at a time. Queries can access multiple tables at once, or access the same table in such a way that multiple rows of the table

The postgres_fdw module provides the foreign-data wrapper postgres_fdw, which can be used to access data stored in