unaccent
  • References/Database/PostgreSQL/Appendixes/Additional Supplied Modules

unaccent is a text search dictionary that removes accents (diacritic signs) from lexemes. It's a filtering dictionary, which means its output

2025-01-10 15:47:30
Parallel Plans
  • References/Database/PostgreSQL/Parallel Query

Because each worker executes the parallel portion of the plan to completion, it is not possible to simply take an ordinary query plan and run it using multiple workers. Each

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

This module implements the hstore data type for storing sets of key/value pairs within a single PostgreSQL value

2025-01-10 15:47:30
Text Search Functions and Operators
  • References/Database/PostgreSQL/Functions/Text Search

Table 9-39, Table 9-40 and Table 9-41 summarize the functions and operators that are provided for full text searching. See Chapter 12 for a detailed explanation of

2025-01-10 15:47:30
Default Values
  • References/Database/PostgreSQL/Data Definition

A column can be assigned a default value. When a new row is created and no values are specified for some of the columns, those columns will be filled with their respective

2025-01-10 15:47:30
CREATE FOREIGN TABLE
  • References/Database/PostgreSQL/Commands

NameCREATE FOREIGN TABLE -- define a new foreign table Synopsis

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

NameLOAD -- load a shared library file Synopsis

2025-01-10 15:47:30
Type Conversion
  • References/Database/PostgreSQL/Type Conversion

SQL is a strongly typed language. That is, every data item has an associated data type which determines its behavior and allowed usage.

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

Namecreatelang -- install a PostgreSQL procedural language

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

auth_delay causes the server to pause briefly before reporting authentication failure, to make brute-force attacks on database passwords more

2025-01-10 15:47:30