Each table has a primary heap disk file where most of the data is stored. If the table has any columns with potentially-wide values, there also might be a

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

NameALTER ROLE -- change a database role Synopsis

The pg_stat_statements module provides a means for tracking execution statistics of all SQL statements executed by a server. The

NameROLLBACK PREPARED -- cancel a transaction that was earlier prepared for two-phase commit

The modification of data that is already in the database is referred to as updating. You can update individual rows, all the rows in a table, or a subset of all rows. Each

NameALTER SEQUENCE -- change the definition of a sequence generator Synopsis

This section describes functions and operators for examining and manipulating values of type bytea.

Window functions provide the ability to perform calculations across sets of rows that are related to the current query row. See

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