June 4, 2026:
PostgreSQL 19 Beta 1 Released!
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_logicalinspect — logical decoding components inspection
- F.29. pg_overexplain — allow EXPLAIN to dump even more details
- F.30. pg_prewarm — preload relation data into buffer caches
- F.31. pgrowlocks — show a table's row locking information
- F.32. pg_stat_statements — track statistics of SQL planning and execution
- F.33. pgstattuple — obtain tuple-level statistics
- F.34. pg_surgery — perform low-level surgery on relation data
- F.35. pg_trgm — support for similarity of text using trigram matching
- F.36. pg_visibility — visibility map information and utilities
- F.37. pg_walinspect — low-level WAL inspection
- F.38. postgres_fdw — access data stored in external PostgreSQL servers
- F.39. seg — a datatype for line segments or floating point intervals
- F.40. sepgsql — SELinux-, label-based mandatory access control (MAC) security module
- F.41. spi — Server Programming Interface features/examples
- F.42. sslinfo — obtain client SSL information
- F.43. tablefunc — functions that return tables (
crosstaband others) - F.44. tcn — a trigger function to notify listeners of changes to table content
- F.45. test_decoding — SQL-based test/example module for WAL logical decoding
- F.46. tsm_system_rows — the
SYSTEM_ROWSsampling method forTABLESAMPLE - F.47. tsm_system_time — the
SYSTEM_TIMEsampling method forTABLESAMPLE - F.48. unaccent — a text search dictionary which removes diacritics
- F.49. uuid-ossp — a UUID generator
- F.50. 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
Submit correction
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.