Binary Data Types
  • References/Database/PostgreSQL/Data Types

The bytea data type allows storage of binary strings; see Table 8-6. Table 8-6. Binary

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

The view pg_user_mappings provides access to information about user mappings. This is essentially a publicly readable view of

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

The view pg_timezone_abbrevs provides a list of time zone abbreviations that are currently recognized by the datetime input routines. The contents

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

Traditionally, implementing a new index access method meant a lot of difficult work. It was necessary to understand the inner workings of the database, such as the lock manager

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

NameROLLBACK -- abort the current transaction Synopsis

2025-01-10 15:47:30
ROLLBACK PREPARED
  • References/Database/PostgreSQL/Commands

NameROLLBACK PREPARED -- cancel a transaction that was earlier prepared for two-phase commit

2025-01-10 15:47:30
Monitoring: Dynamic Tracing
  • References/Database/PostgreSQL/Monitoring

PostgreSQL provides facilities to support dynamic tracing of the database server. This allows an external utility to be called at specific

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

This module implements a data type ltree for representing labels of data stored in a hierarchical tree-like structure. Extensive facilities for searching

2025-01-10 15:47:30
Lexical Structure
  • References/Database/PostgreSQL/Syntax

SQL input consists of a sequence of commands. A command is composed of a sequence of tokens, terminated by a semicolon (

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

19.4.1. Memory shared_buffers (integer)

2025-01-10 15:47:30