Additional Supplied Modules

This section describes additional modules available in the Greenplum Database installation. These modules may be PostgreSQL- or Greenplum-sourced.

contrib modules are typically packaged as extensions. You register a module in a database using the CREATE EXTENSION command. You remove a module from a database with DROP EXTENSION.

The following Greenplum Database and PostgreSQL contrib modules are installed; refer to the linked module documentation for usage instructions.

• auto_explain Provides a means for logging execution plans of slow statements automatically.
• citext - Provides a case-insensitive, multibyte-aware text data type.
• dblink - Provides connections to other Greenplum databases.
• diskquota - Allows administrators to set disk usage quotas for Greenplum Database roles and schemas.
• fuzzystrmatch - Determines similarities and differences between strings.
• gp_sparse_vector - Implements a Greenplum Database 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 PostgreSQL value.
• orafce - Provides Greenplum Database-specific Oracle SQL compatibility functions.
• pageinspect - Provides functions for low level inspection of the contents of database pages; available to superusers only.
• pgcrypto - Provides cryptographic functions for Greenplum Database.
• sslinfo - Provides information about the SSL certificate that the current client provided when connecting to Greenplum.

Need help? Visit the Greenplum Database Community