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
The catalog pg_largeobject_metadata holds metadata associated with large objects. The actual large object data is stored in
Page 26 of 60