Full Text Search: Dictionaries
  • References/Database/PostgreSQL/Full Text Search

Dictionaries are used to eliminate words that should not be considered in a search (stop words), and to normalize words so

2025-01-10 15:47:30
ALTER VIEW
  • References/Database/PostgreSQL/Commands

NameALTER VIEW -- change the definition of a view Synopsis

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
CREATE DOMAIN
  • References/Database/PostgreSQL/Commands

NameCREATE DOMAIN -- define a new domain Synopsis

2025-01-10 15:47:30
test_decoding
  • References/Database/PostgreSQL/Appendixes/Additional Supplied Modules

test_decoding is an example of a logical decoding output plugin. It doesn't do anything especially useful, but can serve as a starting point for

2025-01-10 15:47:30
LIMIT and OFFSET
  • References/Database/PostgreSQL/Queries

LIMIT and OFFSET allow you to retrieve just a portion of the rows that are generated by the rest of the query:

2025-01-10 15:47:30
Internals//BRIN Indexes: Built-in Operator Classes
  • References/Database/PostgreSQL/Internals/BRIN Indexes

The core PostgreSQL distribution includes the BRIN operator classes shown in Table 64-1.

2025-01-10 15:47:30
Date/Time Configuration Files
  • References/Database/PostgreSQL/Appendixes/DateTime Support

Since timezone abbreviations are not well standardized, PostgreSQL provides a means to customize the set of abbreviations accepted by the server

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
CREATE USER
  • References/Database/PostgreSQL/Commands

NameCREATE USER -- define a new database role Synopsis

2025-01-10 15:47:30