Part VIII. Appendixes#
Part VIII. Appendixes
Table of Contents
- A. Tantor SE 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. spi — Server Programming Interface features/examples
- F.11. credcheck
- F.12. cube — a multi-dimensional cube data type
- F.13. dbcopies_decoding
- F.14. dblink — connect to other PostgreSQL databases
- F.15. dict_int — example full-text search dictionary for integers
- F.16. dict_xsyn — example synonym full-text search dictionary
- F.17. earthdistance — calculate great-circle distances
- F.18. fasttrun
- F.19. file_fdw — access data files in the server's file system
- F.20. fulleq
- F.21. fuzzystrmatch — determine string similarities and distance
- F.22. hstore — hstore key/value datatype
- F.23. Hydra Optimized Row Columnar (ORC)
- F.24. HypoPG
- F.25. intagg — integer aggregator and enumerator
- F.26. intarray — manipulate arrays of integers
- F.27. isn — data types for international standard numbers (ISBN, EAN, UPC, etc.)
- F.28. lo — manage large objects
- F.29. ltree — hierarchical tree-like data type
- F.30. mchar
- F.31. OAuth 2.0 Basic Token Validator for PostgreSQL
- F.32. online_analyze
- F.33. Orafce Documentation
- F.34. pageinspect — low-level inspection of database pages
- F.35. page_repair
- F.36. passwordcheck — verify password strength
- F.37. pg_archive
- F.38. pgAudit
- F.39. pgAudit Log to File
- F.40. pg_background
- F.41. pg_buffercache — inspect Tantor SE buffer cache state
- F.42. pg_cron
- F.43. pgcrypto — cryptographic functions
- F.44. pg_freespacemap — examine the free space map
- F.45. pg_hint_plan
- F.46. pg_ivm
- F.47. Transparent Logical DDL Replication (pgl_ddl_deploy)
- F.48. pg_partman
- F.49. pg_prewarm — preload relation data into buffer caches
- F.50. PGQ
- F.51. pg_qualstats
- F.52. pg_query_id
- F.53. pg_repack
- F.54. pgrowlocks — show a table's row locking information
- F.55. pgsql-http PostgreSQL HTTP Client
- F.56. pg_stat_advisor
- F.57. pg_stat_kcache
- F.58. pg_stat_statements — track statistics of SQL planning and execution
- F.59. pgstattuple — obtain tuple-level statistics
- F.60. pg_store_plans
- F.61. pg_surgery — perform low-level surgery on relation data
- F.62. pg_tde
- F.63. pg_throttle
- F.64. pg_trace
- F.65. pg_trgm — support for similarity of text using trigram matching
- F.66. pg_uuidv7
- F.67. pg_variables
- F.68. pg_visibility — visibility map information and utilities
- F.69. pg_wait_sampling
- F.70. pg_walinspect — low-level WAL inspection
- F.71. plantuner
- F.72. postgres_fdw — access data stored in external Tantor SE servers
- F.73. seg — a datatype for line segments or floating point intervals
- F.74. sepgsql — SELinux-, label-based mandatory access control (MAC) security module
- F.75. sslinfo — obtain client SSL information
- F.76. tablefunc — functions that return tables (
crosstab
and others) - F.77. tcn — a trigger function to notify listeners of changes to table content
- F.78. test_decoding — SQL-based test/example module for WAL logical decoding
- F.79. transp_anon
- F.80. tsm_system_rows —
the
SYSTEM_ROWS
sampling method forTABLESAMPLE
- F.81. tsm_system_time —
the
SYSTEM_TIME
sampling method forTABLESAMPLE
- F.82. unaccent — a text search dictionary which removes diacritics
- F.83. uuid-ossp — a UUID generator
- F.84. vector (pgvector)
- F.85. wal2json
- F.86. xml2 — XPath querying and XSLT functionality
- G. Additional Supplied Programs
- H. Additional External Modules
- I. External Projects
- J. Tantor SE Limits
- K. Acronyms
- L. Glossary
- M. Color Support
- N. Obsolete or Renamed Features