The catalog pg_opclass defines index access method operator classes. Each operator class defines semantics for index columns of a particular
NameDROP GROUP -- remove a database role Synopsis
NameDROP CAST -- remove a cast Synopsis
The collation feature allows specifying the sort order and character classification behavior of data per-column, or even per-operation. This alleviates the restriction that
A single index scan can only use query clauses that use the index's columns with operators of its operator class and are joined with AND. For example
SP-GiST offers an interface with a high level of abstraction, requiring the access method developer to implement only methods specific to
GiST stands for Generalized Search Tree. It is a balanced, tree-structured access method, that acts as a base template in which to implement
Namecreateuser -- define a new PostgreSQL user account
Transactions are a fundamental concept of all database systems. The essential point of a transaction is that it bundles multiple steps into a single
The catalog pg_statistic stores statistical data about the contents of the database. Entries are created by
Page 39 of 60