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
PostgreSQL allows functions that have named parameters to be called using either positional or named
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
In addition to the system catalogs, PostgreSQL provides a number of built-in views. Some system views provide convenient access to some commonly
PostgreSQL supports basic table partitioning. This section describes why and how to implement partitioning as part of your database design
Client authentication is controlled by a configuration file, which traditionally is named pg_hba.conf and is stored in the database cluster's
The catalog pg_event_trigger stores event triggers. See Chapter 38 for more information.
NameCREATE MATERIALIZED VIEW -- define a new materialized view Synopsis
NameDROP OPERATOR -- remove an operator Synopsis
NameALTER TYPE -- change the definition of a type Synopsis
Page 22 of 60