Appendix F. Additional Supplied Modules

Appendix F. Additional Supplied Modules
Prev	Up	Part VIII. Appendixes	Home	Next

Appendix F. Additional Supplied Modules

Table of Contents

F.1. adminpack

F.2. amcheck

F.2.1. Functions
F.2.2. Optional heapallindexed Verification
F.2.3. Using amcheck Effectively
F.2.4. Repairing Corruption

F.3. auth_delay

F.3.1. Configuration Parameters
F.3.2. Author

F.4. auto_explain

F.4.1. Configuration Parameters
F.4.2. Example
F.4.3. Author

F.5.1. Parameters
F.5.2. Examples
F.5.3. Operator Class Interface
F.5.4. Limitations
F.5.5. Authors

F.6. btree_gin

F.6.1. Example Usage
F.6.2. Authors

F.7. btree_gist

F.7.1. Example Usage
F.7.2. Authors

F.8. citext

F.8.1. Rationale
F.8.2. How to Use It
F.8.3. String Comparison Behavior
F.8.4. Limitations
F.8.5. Author

F.9.1. Syntax
F.9.2. Precision
F.9.3. Usage
F.9.4. Defaults
F.9.5. Notes
F.9.6. Credits

F.10. dblink

dblink_connect — opens a persistent connection to a remote database
dblink_connect_u — opens a persistent connection to a remote database, insecurely
dblink_disconnect — closes a persistent connection to a remote database
dblink — executes a query in a remote database
dblink_exec — executes a command in a remote database
dblink_open — opens a cursor in a remote database
dblink_fetch — returns rows from an open cursor in a remote database
dblink_close — closes a cursor in a remote database
dblink_get_connections — returns the names of all open named dblink connections
dblink_error_message — gets last error message on the named connection
dblink_send_query — sends an async query to a remote database
dblink_is_busy — checks if connection is busy with an async query
dblink_get_notify — retrieve async notifications on a connection
dblink_get_result — gets an async query result
dblink_cancel_query — cancels any active query on the named connection
dblink_get_pkey — returns the positions and field names of a relation's primary key fields
dblink_build_sql_insert — builds an INSERT statement using a local tuple, replacing the primary key field values with alternative supplied values
dblink_build_sql_delete — builds a DELETE statement using supplied values for primary key field values
dblink_build_sql_update — builds an UPDATE statement using a local tuple, replacing the primary key field values with alternative supplied values

F.11. dict_int

F.11.1. Configuration
F.11.2. Usage

F.12. dict_xsyn

F.12.1. Configuration
F.12.2. Usage

F.13. earthdistance

F.13.1. Cube-Based Earth Distances
F.13.2. Point-Based Earth Distances

F.14. file_fdw

F.15. fuzzystrmatch

F.15.1. Soundex
F.15.2. Levenshtein
F.15.3. Metaphone
F.15.4. Double Metaphone

F.16. hstore

F.16.1. hstore External Representation
F.16.2. hstore Operators and Functions
F.16.3. Indexes
F.16.4. Examples
F.16.5. Statistics
F.16.6. Compatibility
F.16.7. Transforms
F.16.8. Authors

F.17. intagg

F.17.1. Functions
F.17.2. Sample Uses

F.18. intarray

F.18.1. intarray Functions and Operators
F.18.2. Index Support
F.18.3. Example
F.18.4. Benchmark
F.18.5. Authors

F.19.1. Data Types
F.19.2. Casts
F.19.3. Functions and Operators
F.19.4. Examples
F.19.5. Bibliography
F.19.6. Author

F.20.1. Rationale
F.20.2. How to Use It
F.20.3. Limitations
F.20.4. Author

F.21. ltree

F.21.1. Definitions
F.21.2. Operators and Functions
F.21.3. Indexes
F.21.4. Example
F.21.5. Transforms
F.21.6. Authors

F.22. old_snapshot

F.22.1. Functions

F.23. pageinspect

F.23.1. General Functions
F.23.2. Heap Functions
F.23.3. B-Tree Functions
F.23.4. BRIN Functions
F.23.5. GIN Functions
F.23.6. GiST Functions
F.23.7. Hash Functions

F.24. passwordcheck

F.25. pg_buffercache

F.25.1. The pg_buffercache View
F.25.2. Sample Output
F.25.3. Authors

F.26. pgcrypto

F.26.1. General Hashing Functions
F.26.2. Password Hashing Functions
F.26.3. PGP Encryption Functions
F.26.4. Raw Encryption Functions
F.26.5. Random-Data Functions
F.26.6. Notes
F.26.7. Author

F.27. pg_freespacemap

F.27.1. Functions
F.27.2. Sample Output
F.27.3. Author

F.28. pg_prewarm

F.28.1. Functions
F.28.2. Configuration Parameters
F.28.3. Author

F.29. pgrowlocks

F.29.1. Overview
F.29.2. Sample Output
F.29.3. Author

F.30. pg_stat_statements

F.30.1. The pg_stat_statements View
F.30.2. The pg_stat_statements_info View
F.30.3. Functions
F.30.4. Configuration Parameters
F.30.5. Sample Output
F.30.6. Authors

F.31. pgstattuple

F.31.1. Functions
F.31.2. Authors

F.32. pg_surgery

F.32.1. Functions
F.32.2. Authors

F.33. pg_trgm

F.33.1. Trigram (or Trigraph) Concepts
F.33.2. Functions and Operators
F.33.3. GUC Parameters
F.33.4. Index Support
F.33.5. Text Search Integration
F.33.6. References
F.33.7. Authors

F.34. pg_visibility

F.34.1. Functions
F.34.2. Author

F.35. postgres_fdw

F.35.1. FDW Options of postgres_fdw
F.35.2. Functions
F.35.3. Connection Management
F.35.4. Transaction Management
F.35.5. Remote Query Optimization
F.35.6. Remote Query Execution Environment
F.35.7. Cross-Version Compatibility
F.35.8. Examples
F.35.9. Author

F.36.1. Rationale
F.36.2. Syntax
F.36.3. Precision
F.36.4. Usage
F.36.5. Notes
F.36.6. Credits

F.37. sepgsql

F.37.1. Overview
F.37.2. Installation
F.37.3. Regression Tests
F.37.4. GUC Parameters
F.37.5. Features
F.37.6. Sepgsql Functions
F.37.7. Limitations
F.37.8. External Resources
F.37.9. Author

F.38.1. refint — Functions for Implementing Referential Integrity
F.38.2. autoinc — Functions for Autoincrementing Fields
F.38.3. insert_username — Functions for Tracking Who Changed a Table
F.38.4. moddatetime — Functions for Tracking Last Modification Time

F.39. sslinfo

F.39.1. Functions Provided
F.39.2. Author

F.40. tablefunc

F.40.1. Functions Provided
F.40.2. Author

F.42. test_decoding

F.43. tsm_system_rows

F.43.1. Examples