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

The auto_explain module provides a means for logging execution plans of slow statements automatically, without having to run

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

The xml2 module provides XPath querying and XSLT functionality. F.46.1. Deprecation

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
History of Units
  • References/Database/PostgreSQL/Appendixes/DateTime Support

The SQL standard states that "Within the definition of a 'datetime literal', the 'datetime values'

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
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
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
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