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

Information about text search configuration objects can be obtained in psql using a set of commands:

Each heap relation has a Visibility Map (VM) to keep track of which pages contain only tuples that are known to be visible to all active transactions; it also keeps track of

The following subsections describe the authentication methods in more detail. 20.3.1. Trust Authentication

Bit strings are strings of 1's and 0's. They can be used to store or visualize bit masks. There are two SQL bit types: bit(n)

VALUES provides a way to generate a "constant table" that can be used in a query without having to actually create and

When you create complex database structures involving many tables with foreign key constraints, views, triggers, functions, etc. you implicitly create a net of dependencies

btree_gin provides sample GIN operator classes that implement B-tree equivalent behavior for the data types int2,

Namedroplang -- remove a PostgreSQL procedural language

NameROLLBACK -- abort the current transaction Synopsis