CREATE TRANSFORM
  • References/Database/PostgreSQL/Commands

NameCREATE TRANSFORM -- define a new transform Synopsis

2025-01-10 15:47:30
Server Configuration: Client Connection Defaults
  • References/Database/PostgreSQL/Server Configuration

19.11.1. Statement Behavior search_path (string)

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

The PostgreSQL source distribution includes several examples of index operator classes for SP-GiST, as described

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

The catalog pg_foreign_data_wrapper stores foreign-data wrapper definitions. A foreign-data wrapper is the mechanism by which external data

2025-01-10 15:47:30
Internals//Index Access Method: Index Cost Estimation Functions
  • References/Database/PostgreSQL/Internals/Index Access Method

The amcostestimate function is given information describing a possible index scan, including lists of WHERE and ORDER BY clauses that have been

2025-01-10 15:47:30
Internals//Index Access Method: Basic API Structure for Indexes
  • References/Database/PostgreSQL/Internals/Index Access Method

Each index access method is described by a row in the pg_am

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

restore_command (string) The local shell command to execute to retrieve

2025-01-10 15:47:30
Text Search Types
  • References/Database/PostgreSQL/Data Types

PostgreSQL provides two data types that are designed to support full text search, which is the activity of searching through a collection of

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

NameUNLISTEN -- stop listening for a notification Synopsis

2025-01-10 15:47:30
Continuous Archiving and Point-in-Time Recovery (PITR)
  • References/Database/PostgreSQL/Backup and Restore

At all times, PostgreSQL maintains a write ahead log (WAL) in the pg_xlog/ subdirectory

2025-01-10 15:47:30