Appendix F. Additional Supplied Modules and Extensions

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

Table of Contents

F.1. adminpack — pgAdmin support toolpack

F.2. amcheck — tools to verify table and index consistency

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 — pause on authentication failure

F.3.1. Configuration Parameters
F.3.2. Author

F.4. auto_explain — log execution plans of slow queries

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

F.5. basebackup_to_shell — example "shell" pg_basebackup module

F.5.1. Configuration Parameters
F.5.2. Author

F.6. basic_archive — an example WAL archive module

F.6.1. Configuration Parameters
F.6.2. Notes
F.6.3. Author

F.7. bloom — bloom filter index access method

F.7.1. Parameters
F.7.2. Examples
F.7.3. Operator Class Interface
F.7.4. Limitations
F.7.5. Authors

F.8. btree_gin — GIN operator classes with B-tree behavior

F.8.1. Example Usage
F.8.2. Authors

F.9. btree_gist — GiST operator classes with B-tree behavior

F.9.1. Example Usage
F.9.2. Authors

F.10. citext — a case-insensitive character string type

F.10.1. Rationale
F.10.2. How to Use It
F.10.3. String Comparison Behavior
F.10.4. Limitations
F.10.5. Author

F.11. cube — a multi-dimensional cube data type

F.11.1. Syntax
F.11.2. Precision
F.11.3. Usage
F.11.4. Defaults
F.11.5. Notes
F.11.6. Credits

F.12. dblink — connect to other PostgreSQL databases

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 +Appendix F. Additional Supplied Modules and Extensions
Appendix F. Additional Supplied Modules and Extensions
Prev Up Part VIII. Appendixes Home Next
Appendix F. Additional Supplied Modules and Extensions
Table of Contents
F.1. adminpack — pgAdmin support toolpack
F.2. amcheck — tools to verify table and index consistency
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 — pause on authentication failure
F.3.1. Configuration Parameters
F.3.2. Author
F.4. auto_explain — log execution plans of slow queries
F.4.1. Configuration Parameters
F.4.2. Example
F.4.3. Author
F.5. basebackup_to_shell — example "shell" pg_basebackup module
F.5.1. Configuration Parameters
F.5.2. Author
F.6. basic_archive — an example WAL archive module
F.6.1. Configuration Parameters
F.6.2. Notes
F.6.3. Author
F.7. bloom — bloom filter index access method
F.7.1. Parameters
F.7.2. Examples
F.7.3. Operator Class Interface
F.7.4. Limitations
F.7.5. Authors
F.8. btree_gin — GIN operator classes with B-tree behavior
F.8.1. Example Usage
F.8.2. Authors
F.9. btree_gist — GiST operator classes with B-tree behavior
F.9.1. Example Usage
F.9.2. Authors
F.10. citext — a case-insensitive character string type
F.10.1. Rationale
F.10.2. How to Use It
F.10.3. String Comparison Behavior
F.10.4. Limitations
F.10.5. Author
F.11. cube — a multi-dimensional cube data type
F.11.1. Syntax
F.11.2. Precision
F.11.3. Usage
F.11.4. Defaults
F.11.5. Notes
F.11.6. Credits
F.12. dblink — connect to other PostgreSQL databases
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 @@ -101,4 +101,4 @@ CREATE EXTENSION extension_name; by way of shared_preload_libraries. See the documentation of each component for details. -
Prev Up Next
E.4. Prior Releases Home F.1. adminpack — pgAdmin support toolpack
\ No newline at end of file +
Prev Up Next
E.5. Prior Releases Home F.1. adminpack — pgAdmin support toolpack
\ No newline at end of file -- cgit v1.2.3

Prev	Up	Next
E.4. Prior Releases	Home	F.1. adminpack — pgAdmin support toolpack

Prev	Up	Next
E.5. Prior Releases	Home	F.1. adminpack — pgAdmin support toolpack