Catalogs: pg_opclass
  • References/Database/PostgreSQL/Internals: Catalogs

The catalog pg_opclass defines index access method operator classes. Each operator class defines semantics for index columns of a particular

2025-01-10 15:47:30
DROP GROUP
  • References/Database/PostgreSQL/Commands

NameDROP GROUP -- remove a database role Synopsis

2025-01-10 15:47:30
DROP CAST
  • References/Database/PostgreSQL/Commands

NameDROP CAST -- remove a cast Synopsis

2025-01-10 15:47:30
Collation Support
  • References/Database/PostgreSQL/Localization

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

2025-01-10 15:47:30
Combining Multiple Indexes
  • References/Database/PostgreSQL/Indexes

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

2025-01-10 15:47:30
Internals//SP-GiST Indexes: Extensibility
  • References/Database/PostgreSQL/Internals/SP-GiST Indexes

SP-GiST offers an interface with a high level of abstraction, requiring the access method developer to implement only methods specific to

2025-01-10 15:47:30
Internals//GiST Indexes
  • References/Database/PostgreSQL/Internals/GiST Indexes

GiST stands for Generalized Search Tree. It is a balanced, tree-structured access method, that acts as a base template in which to implement

2025-01-10 15:47:30
createuser
  • References/Database/PostgreSQL/Applications

Namecreateuser -- define a new PostgreSQL user account

2025-01-10 15:47:30
4.
  • References/Database/PostgreSQL/Tutorial/Advanced Features

Transactions are a fundamental concept of all database systems. The essential point of a transaction is that it bundles multiple steps into a single

2025-01-10 15:47:30
Catalogs: pg_statistic
  • References/Database/PostgreSQL/Internals: Catalogs

The catalog pg_statistic stores statistical data about the contents of the database. Entries are created by

2025-01-10 15:47:30