Enum Functions
  • References/Database/PostgreSQL/Functions and Operators

For enum types (described in Section 8.7), there are several functions that allow cleaner programming

2025-01-10 15:47:30
Dropping Roles
  • References/Database/PostgreSQL/Database Roles

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

2025-01-10 15:47:30
Destroying a Database
  • References/Database/PostgreSQL/Managing Databases

Databases are destroyed with the command DROP DATABASE:

2025-01-10 15:47:30
Locale Support
  • References/Database/PostgreSQL/Localization

Locale support refers to an application respecting cultural preferences regarding alphabets, sorting, number formatting, etc.

2025-01-10 15:47:30
tsm_system_rows
  • References/Database/PostgreSQL/Appendixes/Additional Supplied Modules

The tsm_system_rows module provides the table sampling method SYSTEM_ROWS, which can be used in the

2025-01-10 15:47:30
Log-Shipping Standby Servers
  • References/Database/PostgreSQL/High Availability

Continuous archiving can be used to create a high availability (HA) cluster configuration with one or more standby servers

2025-01-10 15:47:30
System Catalogs
  • References/Database/PostgreSQL/Internals: Catalogs

Table 50-1 lists the system catalogs. More detailed documentation of each catalog follows below. Most system catalogs are copied from the template

2025-01-10 15:47:30
CREATE SEQUENCE
  • References/Database/PostgreSQL/Commands

NameCREATE SEQUENCE -- define a new sequence generator Synopsis

2025-01-10 15:47:30
reindexdb
  • References/Database/PostgreSQL/Applications

Namereindexdb -- reindex a PostgreSQL database

2025-01-10 15:47:30
pg_buffercache
  • References/Database/PostgreSQL/Appendixes/Additional Supplied Modules

The pg_buffercache module provides a means for examining what's happening in the shared buffer cache in real time. The

2025-01-10 15:47:30