An alternative to the built-in standby mode described in the previous sections is to use a restore_command that polls the archive location. This

These settings control the behavior of the autovacuum feature. Refer to Section 24.1.6 for more information. Note that many of these settings can be

Mathematical operators are provided for many PostgreSQL types. For types without standard mathematical conventions (e.g., date/time types)

The catalog pg_index contains part of the information about indexes. The rest is mostly in pg_class.

A table in a relational database is much like a table on paper: It consists of rows and columns. The number and order of the columns is fixed, and each column has a name. The

NameCREATE EXTENSION -- install an extension Synopsis

Data types are a way to limit the kind of data that can be stored in a table. For many applications, however, the constraint they provide is too coarse. For example, a column

NameTRUNCATE -- empty a table or set of tables Synopsis

NameDROP TEXT SEARCH TEMPLATE -- remove a text search template Synopsis

NameALTER TYPE -- change the definition of a type Synopsis