Catalogs: pg_available_extension_versions
  • References/Database/PostgreSQL/Internals: Catalogs

The pg_available_extension_versions view lists the specific extension versions that are available for installation. See also the

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

The catalog pg_largeobject_metadata holds metadata associated with large objects. The actual large object data is stored in

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
Aggregate Functions
  • References/Database/PostgreSQL/Functions/Aggregate

Aggregate functions compute a single result from a set of input values. The built-in normal aggregate functions are listed in Table 9-51 and Table

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

The index construction and maintenance functions that an index access method must provide in IndexAmRoutine are:

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

The spi module provides several workable examples of using SPI and triggers. While these functions are of some value in their own right, they

2025-01-10 15:47:30
Full Text Search: Controlling Text Search
  • References/Database/PostgreSQL/Full Text Search

To implement full text searching there must be a function to create a tsvector from a document and a tsquery from a user

2025-01-10 15:47:30
Transaction Isolation
  • References/Database/PostgreSQL/Concurrency Control

The SQL standard defines four levels of transaction isolation. The most strict is Serializable, which is defined by the standard in a paragraph

2025-01-10 15:47:30
3.
  • References/Database/PostgreSQL/Tutorial/Getting Started

The first test to see whether you can access the database server is to try to create a database. A running PostgreSQL server can manage many

2025-01-10 15:47:30
Full Text Search: Configuration Example
  • References/Database/PostgreSQL/Full Text Search

A text search configuration specifies all options necessary to transform a document into a tsvector: the parser to use to break text into tokens,

2025-01-10 15:47:30