Extension modules distributed with PostgreSQL
The postgresql-contrib package contains various extension modules that are
included in the PostgreSQL distribution.
Version: 16.1
See also: postgresql, postgresql-server, postgresql-server-devel.
General Commands | |
| oid2name | resolve OIDs and file nodes in a PostgreSQL data directory |
| pg_amcheck | checks for corruption in one or more PostgreSQL databases |
| pg_archivecleanup | clean up PostgreSQL WAL archive files |
| pg_recvlogical | control PostgreSQL logical decoding streams |
| pg_test_fsync | determine fastest wal_sync_method for PostgreSQL |
| pg_test_timing | measure timing overhead |
| pg_waldump | display a human-readable rendering of the write-ahead log of a PostgreSQL database cluster |
| pgbench | run a benchmark test on PostgreSQL |
| vacuumlo | remove orphaned large objects from a PostgreSQL database |
Library Functions | |
| dblink | executes a query in a remote database |
| dblink_build_sql_delete | builds a DELETE statement using supplied values for primary key field values |
| 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_update | builds an UPDATE statement using a local tuple, replacing the primary key field values with alternative supplied values |
| dblink_cancel_query | cancels any active query on the named connection |
| dblink_close | closes a cursor in a remote database |
| 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_error_message | gets last error message on the named connection |
| dblink_exec | executes a command in a remote database |
| dblink_fetch | returns rows from an open cursor in a remote database |
| dblink_get_connections | returns the names of all open named dblink connections |
| dblink_get_notify | retrieve async notifications on a connection |
| dblink_get_pkey | returns the positions and field names of a relation's primary key fields |
| dblink_get_result | gets an async query result |
| dblink_is_busy | checks if connection is busy with an async query |
| dblink_open | opens a cursor in a remote database |
| dblink_send_query | sends an async query to a remote database |