Date/Time Configuration Files
  • References/Database/PostgreSQL/Appendixes/DateTime Support

Since timezone abbreviations are not well standardized, PostgreSQL provides a means to customize the set of abbreviations accepted by the server

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

NameCREATE DOMAIN -- define a new domain Synopsis

2025-01-10 15:47:30
Combining Multiple Indexes
  • References/Database/PostgreSQL/Indexes

A single index scan can only use query clauses that use the index's columns with operators of its operator class and are joined with AND. For example

2025-01-10 15:47:30
4.
  • References/Database/PostgreSQL/Tutorial/Advanced Features

Transactions are a fundamental concept of all database systems. The essential point of a transaction is that it bundles multiple steps into a single

2025-01-10 15:47:30
Recovery Target Settings
  • References/Database/PostgreSQL/Recovery Configuration

By default, recovery will recover to the end of the WAL log. The following parameters can be used to specify an earlier stopping point. At most one of

2025-01-10 15:47:30
Internals//GiST Indexes
  • References/Database/PostgreSQL/Internals/GiST Indexes

GiST stands for Generalized Search Tree. It is a balanced, tree-structured access method, that acts as a base template in which to implement

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

The collation feature allows specifying the sort order and character classification behavior of data per-column, or even per-operation. This alleviates the restriction that

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

NameCREATE CONVERSION -- define a new encoding conversion Synopsis

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

Namepg_upgrade -- upgrade a PostgreSQL server instance

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

The pgstattuple module provides various functions to obtain tuple-level statistics. F

2025-01-10 15:47:30