Part VIII. Appendixes
Table of Contents
- A. Postgres Pro Error Codes
- B. Date/Time Support
- C. SQL Key Words
- D. SQL Conformance
- E. Release Notes
- E.1. Postgres Pro Enterprise 16.10.2
- E.2. Postgres Pro Enterprise 16.10.1
- E.3. Postgres Pro Enterprise 16.9.1
- E.4. Postgres Pro Enterprise 16.8.3
- E.5. Postgres Pro Enterprise 16.8.2
- E.6. Postgres Pro Enterprise 16.8.1
- E.7. Postgres Pro Enterprise 16.6.1
- E.8. Postgres Pro Enterprise 16.4.2
- E.9. Postgres Pro Enterprise 16.4.1
- E.10. Postgres Pro Enterprise 16.3.2
- E.11. Postgres Pro Enterprise 16.3.1
- E.12. Postgres Pro Enterprise 16.2.2
- E.13. Postgres Pro Enterprise 16.2.1
- E.14. Postgres Pro Enterprise 16.1.1
- E.15. Release 16.10
- E.16. Release 16.9
- E.17. Release 16.8
- E.18. Release 16.7
- E.19. Release 16.6
- E.20. Release 16.5
- E.21. Release 16.4
- E.22. Release 16.3
- E.23. Release 16.2
- E.24. Release 16.1
- E.25. Release 16
- E.26. Prior Releases
- E.2. Postgres Pro Enterprise 16.10.1
- E.1. Postgres Pro Enterprise 16.10.2
- F. Additional Supplied Modules and Extensions Shipped in
postgrespro-ent-16-contrib - F.1. adminpack — pgAdmin support toolpack
- F.2. amcheck — tools to verify table and index consistency
- F.3. aqo — cost-based query optimization
- F.4. auth_delay — pause on authentication failure
- F.5. auto_explain — log execution plans of slow queries
- F.6. basebackup_to_shell — example "shell" pg_basebackup module
- F.7. basic_archive — an example WAL archive module
- F.8. biha — built-in high-availability cluster
- F.9. bloom — bloom filter index access method
- F.10. btree_gin — GIN operator classes with B-tree behavior
- F.11. btree_gist — GiST operator classes with B-tree behavior
- F.12. citext — a case-insensitive character string type
- F.13. cube — a multi-dimensional cube data type
- F.14. daterange_inclusive — upper bound-inclusive
daterange- F.15. dbcopies_decoding — 1C module for updating database copies
- F.16. dblink — connect to other Postgres Pro databases
- F.17. dbms_lob — operate on large objects
- F.18. dict_int — example full-text search dictionary for integers
- F.19. dict_xsyn — example synonym full-text search dictionary
- F.20. dump_stat — functions to backup and recover the
pg_statistictable- F.21. earthdistance — calculate great-circle distances
- F.22. fasttrun — a transaction unsafe function to truncate temporary tables
- F.23. file_fdw — access data files in the server's file system
- F.24. fulleq — an additional equivalence operator for compatibility with Microsoft SQL Server
- F.25. fuzzystrmatch — determine string similarities and distance
- F.26. hstore — hstore key/value datatype
- F.27. Hunspell Dictionaries Modules
- F.28. hypopg — support for hypothetical indexes
- F.29. in_memory — store data in shared memory using tables implemented via FDW
- F.30. intagg — integer aggregator and enumerator
- F.31. intarray — manipulate arrays of integers
- F.32. isn — data types for international standard numbers (ISBN, EAN, UPC, etc.)
- F.33. jsquery — a language to query
jsonbdata type- F.34. lo — manage large objects
- F.35. ltree — hierarchical tree-like data type
- F.36. mchar — additional data types for compatibility with Microsoft SQL Server
- F.37. multimaster — synchronous cluster to provide OLTP scalability and high availability
- F.38. online_analyze — update statistics after
INSERT,UPDATE,DELETE,SELECT INTO, orCOPYoperations- F.39. old_snapshot — inspect
old_snapshot_thresholdstate- F.40. pageinspect — low-level inspection of database pages
- F.41. passwordcheck — verify password strength
- F.42. pg_buffercache — inspect Postgres Pro buffer cache state
- F.43. pgcrypto — cryptographic functions
- F.44. pg_freespacemap — examine the free space map
- F.45. pg_pathman — an optimized partitioning solution for large and distributed databases
- F.46. pgpro_application_info — port applications using
DBMS_APPLICATION_INFOpackage- F.47. pgpro_bfile — a composite type to access an external file
- F.48. pg_proaudit — enables detailed logging of various security events
- F.49. pgpro_bindump — a replication protocol module for backup and restore
- F.50. pg_prewarm — preload relation data into buffer caches
- F.51. pgpro_rp — resource prioritization
- F.52. pgpro_scheduler — scheduling, monitoring and managing job execution
- F.53. pgpro_sfile — storage for large objects
- F.54. pg_query_state — a facility to know the current state of query execution on working backend
- F.55. pgrowlocks — show a table's row locking information
- F.56. pg_stat_statements — track statistics of SQL planning and execution
- F.57. pgstattuple — obtain tuple-level statistics
- F.58. pg_surgery — perform low-level surgery on relation data
- F.59. pg_transfer — quick transfer of tables between instances
- F.60. pg_trgm — support for similarity of text using trigram matching
- F.61. pg_tsparser — an extension for text search
- F.62. pg_variables — functions for working with variables of various types
- F.63. pg_visibility — visibility map information and utilities
- F.64. pg_wait_sampling — collecting sampling-based statistics on wait events
- F.65. pg_walinspect — low-level WAL inspection
- F.66. plantuner — hints for the planner to disable or enable indexes for query execution
- F.67. postgres_fdw — access data stored in external Postgres Pro servers
- F.68. ptrack — a block-level incremental backup engine for Postgres Pro
- F.69. referee — manage quorum settings with an even number of nodes configured with multimaster
- F.70. rum — an access method to work with the
RUMindexes- F.71. seg — a datatype for line segments or floating point intervals
- F.72. shared_ispell — a shared ispell dictionary
- F.73. spi — Server Programming Interface features/examples
- F.74. sslinfo — obtain client SSL information
- F.75. tablefunc — functions that return tables (
crosstaband others)- F.76. tcn — a trigger function to notify listeners of changes to table content
- F.77. test_decoding — SQL-based test/example module for WAL logical decoding
- F.78. tsm_system_rows — the
SYSTEM_ROWSsampling method forTABLESAMPLE- F.79. tsm_system_time — the
SYSTEM_TIMEsampling method forTABLESAMPLE- F.80. unaccent — a text search dictionary which removes diacritics
- F.81. uuid-ossp — a UUID generator
- F.82. vops — support for vector operations
- F.83. xml2 — XPath querying and XSLT functionality
- F.2. amcheck — tools to verify table and index consistency
- F.1. adminpack — pgAdmin support toolpack
- G. Postgres Pro Modules and Extensions Shipped as Individual Packages
- G.1. pgpro_anonymizer — mask or replace sensitive data
- G.2. pgpro_datactl — manage Postgres Pro Enterprise data files
- G.3. pgpro_multiplan — save query execution plans for future usage
- G.4. pgpro_pwr — workload reports
- G.5. pgpro_result_cache — save query results for reuse
- G.6. pgpro_stats — a means for tracking planning and execution statistics of all SQL statements executed by a server
- G.7. sr_plan — save a specific plan of a parameterized query for future usage
- G.8. utl_http — access data on the Internet over the HTTP protocol
- G.9. utl_mail — manage emails
- G.10. utl_smtp — send emails over SMTP
- G.2. pgpro_datactl — manage Postgres Pro Enterprise data files
- G.1. pgpro_anonymizer — mask or replace sensitive data
- H. Third-Party Modules and Extensions Shipped as Individual Packages
- H.1. apache_age — graph database functionality
- H.2. oracle_fdw — access to Oracle databases
- H.3. pg_failover_slots — automatic creation and synchronization of logical replication slots on physical replicas
- H.4. pg_hint_plan — control an execution plan with hinting phrases
- H.5. tds_fdw — connect to databases that use the TDS protocol
- H.6. wal2json — convert WAL changes into JSON via logical decoding
- H.2. oracle_fdw — access to Oracle databases
- H.1. apache_age — graph database functionality
- I. Additional Supplied Programs
- J. External Projects
- K. Configuring Postgres Pro for 1C Solutions
- L. Migration Tools in Postgres Pro
- M. Postgres Pro Limits
- N. Demo Database “Airlines”
- O. Acronyms
- P. Glossary
- Q. Color Support
- P. Glossary
- R. Obsolete or Renamed Features