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

The tsm_system_rows module provides the table sampling method SYSTEM_ROWS, which can be used in the

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
tsearch2
  • References/Database/PostgreSQL/Appendixes/Additional Supplied Modules

The tsearch2 module provides backwards-compatible text search functionality for applications that used tsearch2

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

The intarray module provides a number of useful functions and operators for manipulating null-free arrays of integers. There is also support for

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
pg_visibility
  • References/Database/PostgreSQL/Appendixes/Additional Supplied Modules

The pg_visibility module provides a means for examining the visibility map (VM) and page-level visibility information. It also provides functions

2025-01-10 15:47:30
SQL Key Words
  • References/Database/PostgreSQL/Appendixes/Appendixes

Table C-1 lists all tokens that are key words in the SQL standard and in PostgreSQL 9.6.0. Background information can be found in Section 4

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

dict_int is an example of an add-on dictionary template for full-text search. The motivation for this example dictionary is to control the indexing

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

The earthdistance module provides two different approaches to calculating great circle distances on the surface of the Earth. The one described

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

This module implements a data type chkpass that is designed for storing encrypted passwords. Each password is automatically converted to encrypted

2025-01-10 15:47:30