NameCREATE TABLESPACE -- define a new tablespace Synopsis

NameDECLARE -- define a cursor Synopsis

NameCHECKPOINT -- force a transaction log checkpoint Synopsis

This section describes functions that possibly return more than one row. The most widely used functions in this class are series generating functions, as detailed in Table

The following "parameters" are read-only, and are determined when PostgreSQL is compiled or when it is installed

Namedropdb -- remove a PostgreSQL database Synopsis

Write-Ahead Logging (WAL) is a standard method for ensuring data integrity. A detailed description can be found

Recall the weather and cities tables from Chapter 2. Consider the following problem: You want to make sure that

Dictionaries are used to eliminate words that should not be considered in a search (stop words), and to normalize words so

The pg_replication_origin_status view contains information about how far replay for a certain origin has progressed. For more on replication