The pg_available_extension_versions view lists the specific extension versions that are available for installation. See also the
The catalog pg_largeobject_metadata holds metadata associated with large objects. The actual large object data is stored in
The pageinspect module provides functions that allow you to inspect the contents of database pages at a low level, which is useful for debugging
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
The index construction and maintenance functions that an index access method must provide in IndexAmRoutine are:
The spi module provides several workable examples of using SPI and triggers. While these functions are of some value in their own right, they
To implement full text searching there must be a function to create a tsvector from a document and a tsquery from a user
The SQL standard defines four levels of transaction isolation. The most strict is Serializable, which is defined by the standard in a paragraph
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
A text search configuration specifies all options necessary to transform a document into a tsvector: the parser to use to break text into tokens,
Page 32 of 60