Range Types
  • References/Database/PostgreSQL/Data Types

Range types are data types representing a range of values of some element type (called the range's subtype). For instance, ranges of

2025-01-10 15:47:30
Server Configuration: Replication
  • References/Database/PostgreSQL/Server Configuration

These settings control the behavior of the built-in streaming replication feature (see Section 26.2.5). Servers will be either a Master or a Standby

2025-01-10 15:47:30
History of Units
  • References/Database/PostgreSQL/Appendixes/DateTime Support

The SQL standard states that "Within the definition of a 'datetime literal', the 'datetime values'

2025-01-10 15:47:30
ALTER OPERATOR CLASS
  • References/Database/PostgreSQL/Commands

NameALTER OPERATOR CLASS -- change the definition of an operator class Synopsis

2025-01-10 15:47:30
Internals//GIN Indexes: Built-in Operator Classes
  • References/Database/PostgreSQL/Internals/GIN Indexes

The core PostgreSQL distribution includes the GIN operator classes shown in Table 63-1. (Some of the optional

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

The GIN interface has a high level of abstraction, requiring the access method implementer only to implement the semantics of the data type

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

NameCREATE OPERATOR FAMILY -- define a new operator family Synopsis

2025-01-10 15:47:30
Text Search Functions and Operators
  • References/Database/PostgreSQL/Functions/Text Search

Table 9-39, Table 9-40 and Table 9-41 summarize the functions and operators that are provided for full text searching. See Chapter 12 for a detailed explanation of

2025-01-10 15:47:30
PREPARE TRANSACTION
  • References/Database/PostgreSQL/Commands

NamePREPARE TRANSACTION -- prepare the current transaction for two-phase commit

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

The pg_replication_slots view provides a listing of all replication slots that currently exist on the database cluster, along with their current

2025-01-10 15:47:30