For enum types (described in Section 8.7), there are several functions that allow cleaner programming
Because roles can own database objects and can hold privileges to access other objects, dropping a role is often not just a matter of a quick
Databases are destroyed with the command DROP DATABASE:
Locale support refers to an application respecting cultural preferences regarding alphabets, sorting, number formatting, etc.
The tsm_system_rows module provides the table sampling method SYSTEM_ROWS, which can be used in the
Continuous archiving can be used to create a high availability (HA) cluster configuration with one or more standby servers
Table 50-1 lists the system catalogs. More detailed documentation of each catalog follows below. Most system catalogs are copied from the template
NameCREATE SEQUENCE -- define a new sequence generator Synopsis
Namereindexdb -- reindex a PostgreSQL database
The pg_buffercache module provides a means for examining what's happening in the shared buffer cache in real time. The
Page 2 of 60