Additional Supplied Modules

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.