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.

• amcheck - Provides functions for verifying the logical consistency of indexes and heap relations.
• btree_gin - Provides GIN operator classes that implement B-tree equivalent behavior for certain data types.
• citext - Provides a case-insensitive, multibyte-aware text data type.
• dblink - Provides connections to other WarehousePG databases.
• fuzzystrmatch - Determines similarities and differences between strings.
• gp_array_agg - Implements a parallel array_agg() aggregate function for WarehousePG.
• gp_check_functions - Provides views to check for orphaned and missing relation files and a user-defined function to move orphaned files.
• gp_distribution_policy - Provides access to a table's distribution policy information.
• gp_internal_tools - Provides internal diagnostic functions for WarehousePG support and engineering use.
• gp_legacy_string_agg - Implements a legacy, single-argument string_agg() aggregate function that was present in WarehousePG 5.
• gp_parallel_retrieve_cursor - Provides extended cursor functionality to retrieve data, in parallel, directly from WarehousePG segments.
• gp_percentile_agg - Improves GPORCA performance for ordered-set aggregate functions.
• gp_pitr - Supports implementing point-in-time recovery for WarehousePG 6.
• gp_sparse_vector - Implements a data type that uses compressed storage of zeros to make vector computations on floating point numbers faster.
• gp_subtransaction_overflow - Provides a view and user-defined function for querying suboverflowed backends.
• hstore - Provides a data type for storing sets of key/value pairs within a single value.
• isn - Provides support for international product numbering standards (EAN13, UPC, ISBN, ISMN, ISSN).
• 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 database page contents. Available to superusers only.
• pg_buffercache - Provides access to views for obtaining cluster-wide shared buffer metrics.
• pg_trgm - Provides functions and operators for determining the similarity of alphanumeric text based on trigram matching.
• pgcrypto - Provides cryptographic functions.
• PL/Perl - Enables writing functions and triggers in Perl.
• plperlu - Provides an untrusted version of PL/Perl that allows unrestricted operations, such as file and network access.
• PL/pgSQL - Enables writing functions, triggers, and procedural code in a SQL-like language.
• PL/Python - Enables writing functions in Python. Enabled by default as plpythonu (Python 2).
• plpython2u - Provides an explicit Python 2 version of the untrusted PL/Python language.
• plpython3u - Provides an explicit Python 3 version of the untrusted PL/Python language.
• postgres_fdw - Provides a foreign data wrapper for accessing data stored in an external PostgreSQL or WarehousePG database.
• sslinfo - Provides information about the SSL certificate of the current client connection.
• tablefunc - Provides various functions that return tables (multiple rows).
• uuid-ossp - Provides functions to generate universally unique identifiers (UUIDs).