Bundled Modules v7.5

These modules ship with WarehousePG. Activate them in each database with CREATE EXTENSION <module_name>, unless the individual reference page specifies a different activation method.

• adminpack - Provides administrative support functions used by management tools such as pgAdmin.
• amcheck - Provides functions for verifying the logical consistency of indexes and heap relations.
• auto_explain - Logs execution plans of slow statements automatically.
• bloom - Implements a Bloom filter-based index access method for equality comparisons on multiple columns.
• btree_gin - Provides GIN operator classes that implement B-tree equivalent behavior for certain data types.
• btree_gist - Provides GiST operator classes that implement B-tree equivalent behavior for a range of data types.
• citext - Provides a case-insensitive, multibyte-aware text data type.
• cube - Provides a data type for representing multidimensional cubes.
• dblink - Provides connections to other WarehousePG databases.
• dict_int - Provides a text search dictionary template that controls indexing of integers.
• dict_xsyn - Provides a text search dictionary template for extended synonym processing.
• earthdistance - Provides two approaches to calculating great-circle distances on Earth's surface.
• file_fdw - Provides a foreign-data wrapper for accessing data files in the server's file system.
• gp_exttable_fdw - Built-in foreign-data wrapper that internally converts an external table to a foreign table.
• gp_legacy_string_agg - Implements a legacy, single-argument string_agg() aggregate function.
• gp_sparse_vector - Implements a data type that uses compressed storage of zeros to make vector computations on floating point numbers faster.
• hstore - Provides a data type for storing sets of key/value pairs within a single value.
• intarray - Provides additional functions, operators, and index support for arrays of integers with no null elements.
• isn - Provides data types for international product numbering standards (EAN13, UPC, ISBN, ISMN, ISSN).
• lo - Provides support for managing large objects.
• ltree - Provides data types for representing labels of data stored in a hierarchical tree-like structure.
• orafce - Provides Oracle SQL compatibility functions.
• pageinspect - Provides functions for low-level inspection of the contents of database pages. Available to superusers only.
• pg_buffercache - Provides access to views for obtaining cluster-wide shared buffer metrics.
• pg_freespacemap - Provides a function for examining the free space map.
• pg_hint_plan - Allows controlling query execution plans using hints specified in SQL comments.
• pg_prewarm - Provides functions for loading relation data into the buffer cache.
• pg_stat_statements - Tracks execution statistics of all SQL statements. Requires shared_preload_libraries.
• pg_trgm - Provides functions and operators for determining the similarity of alphanumeric text based on trigram matching.
• pg_visibility - Provides functions for examining the visibility map and page-level visibility information of a relation.
• pgcrypto - Provides cryptographic functions.
• pgrowlocks - Provides a function that shows row locking information for a given table.
• pgstattuple - Provides functions for obtaining tuple-level and index-level statistics.
• PL/Perl - Enables writing functions and triggers in Perl.
• PL/pgSQL - Enables writing functions, triggers, and procedural code in a SQL-like language.
• PL/Python - Enables writing functions in Python.
• postgres_fdw - Provides a foreign data wrapper for accessing data stored in an external Postgres database.
• seg - Provides a data type for representing line segments or floating-point intervals.
• sslinfo - Provides information about the SSL certificate of the current client connection.
• tablefunc - Provides various functions that return tables (multiple rows).
• tsm_system_rows - Implements the SYSTEM_ROWS table sampling method.
• tsm_system_time - Implements the SYSTEM_TIME table sampling method.
• unaccent - Provides a text search dictionary that removes accents from lexemes.
• uuid-ossp - Provides functions to generate universally unique identifiers (UUIDs).
• xml2 - Provides XPath querying and XSLT functionality.