Part VIII. Appendixes
Table of Contents
- A. PostgreSQL Error Codes
- B. Date/Time Support
- C. SQL Key Words
- D. SQL Conformance
- E. Release Notes
- F. Additional Supplied Modules and Extensions
-
- F.1. amcheck - tools to verify table and index consistency
- F.2. auth_delay - pause on authentication failure
- F.3. auto_explain - log execution plans of slow queries
- F.4. basebackup_to_shell - example "shell" pg_basebackup module
- F.5. basic_archive - an example WAL archive module
- F.6. bloom - bloom filter index access method
- F.7. btree_gin - GIN operator classes with B-tree behavior
- F.8. btree_gist - GiST operator classes with B-tree behavior
- F.9. citext - a case-insensitive character string type
- F.10. cube - a multi-dimensional cube data type
- F.11. dblink - connect to other PostgreSQL databases
- F.12. dict_int - example full-text search dictionary for integers
- F.13. dict_xsyn - example synonym full-text search dictionary
- F.14. earthdistance - calculate great-circle distances
- F.15. file_fdw - access data files in the server's file system
- F.16. fuzzystrmatch - determine string similarities and distance
- F.17. hstore - hstore key/value datatype
- F.18. intagg - integer aggregator and enumerator
- F.19. intarray - manipulate arrays of integers
- F.20. isn - data types for international standard numbers (ISBN, EAN, UPC, etc.)
- F.21. lo - manage large objects
- F.22. ltree - hierarchical tree-like data type
- F.23. pageinspect - low-level inspection of database pages
- F.24. passwordcheck - verify password strength
- F.25. pg_buffercache - inspect PostgreSQL buffer cache state
- F.26. pgcrypto - cryptographic functions
- F.27. pg_freespacemap - examine the free space map
- F.28. pg_prewarm - preload relation data into buffer caches
- F.29. pgrowlocks - show a table's row locking information
- F.30. pg_stat_statements - track statistics of SQL planning and execution
- F.31. pgstattuple - obtain tuple-level statistics
- F.32. pg_surgery - perform low-level surgery on relation data
- F.33. pg_trgm - support for similarity of text using trigram matching
- F.34. pg_visibility - visibility map information and utilities
- F.35. pg_walinspect - low-level WAL inspection
- F.36. postgres_fdw - access data stored in external PostgreSQL servers
- F.37. seg - a datatype for line segments or floating point intervals
- F.38. sepgsql - SELinux-, label-based mandatory access control (MAC) security module
- F.39. spi - Server Programming Interface features/examples
- F.40. sslinfo - obtain client SSL information
-
F.41. tablefunc - functions that return tables (
crosstaband others) - F.42. tcn - a trigger function to notify listeners of changes to table content
- F.43. test_decoding - SQL-based test/example module for WAL logical decoding
-
F.44. tsm_system_rows -
the
SYSTEM_ROWSsampling method forTABLESAMPLE -
F.45. tsm_system_time -
the
SYSTEM_TIMEsampling method forTABLESAMPLE - F.46. unaccent - a text search dictionary which removes diacritics
- F.47. uuid-ossp - a UUID generator
- F.48. xml2 - XPath querying and XSLT functionality
- G. Additional Supplied Programs
- H. External Projects
- I. The Source Code Repository
- J. Documentation
- K. PostgreSQL Limits
- L. Acronyms
- M. Glossary
- N. Color Support
- O. Obsolete or Renamed Features