In addition to simply finding the rows to be returned by a query, an index may be able to deliver them in a specific sorted order. This allows a query's ORDER

A table expression computes a table. The table expression contains a FROM clause that is optionally followed by

The PostgreSQL source distribution includes GIN operator classes for tsvector

The pg_lsn data type can be used to store LSN (Log Sequence Number) data which is a pointer to a location in the XLOG. This type is a representation

NameBEGIN -- start a transaction block Synopsis

The catalog pg_policy stores row level security policies for tables. A policy includes the kind of command that it applies to (possibly all

PostgreSQL devises a query plan for each query it receives. Choosing the right plan to match the query structure and

GIN stands for Generalized Inverted Index. GIN is designed for handling cases where the items to be indexed

NameIMPORT FOREIGN SCHEMA -- import table definitions from a foreign server Synopsis

The catalog pg_opfamily defines operator families. Each operator family is a collection of operators and associated support routines that implement