droplang
  • References/Database/PostgreSQL/Applications

Namedroplang -- remove a PostgreSQL procedural language

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
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
ALTER AGGREGATE
  • References/Database/PostgreSQL/Commands

NameALTER AGGREGATE -- change the definition of an aggregate function Synopsis

2025-01-10 15:47:30
Formatting Functions
  • References/Database/PostgreSQL/Functions/Data Type Formatting

The PostgreSQL formatting functions provide a powerful set of tools for converting various data types (date/time, integer, floating point,

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

Recall from Chapter 19 that the PostgreSQL server provides a large number of run-time configuration variables. You can set database-specific

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

The pageinspect module provides functions that allow you to inspect the contents of database pages at a low level, which is useful for debugging

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

NameALTER TRIGGER -- change the definition of a trigger Synopsis

2025-01-10 15:47:30
Server Configuration: Connections and Authentication
  • References/Database/PostgreSQL/Server Configuration

19.3.1. Connection Settings listen_addresses (string)

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