Additional Supplied Modules

This section describes additional modules available in the LightDB-A Database installation. These modules may be PostgreSQL- or LightDB-A-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 LightDB-A Database and PostgreSQL contrib modules are installed; refer to the linked module documentation for usage instructions.

  • advanced_password_check Provides password quality checking and policy definition for LightDB-A Database.
  • auto_explain Provides a means for logging execution plans of slow statements automatically.
  • btree_gin - Provides sample generalized inverted index (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 LightDB-A databases.
  • diskquota.md# - Allows administrators to set disk usage quotas for LightDB-A Database roles and schemas.
  • fuzzystrmatch - Determines similarities and differences between strings.
  • gp_legacy_string_agg - Implements a legacy, single-argument string_agg() aggregate function that was present in LightDB-A Database 5.
  • gp_sparse_vector - Implements a LightDB-A 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.
  • ip4r - Provides data types for operations on IPv4 and IPv6 IP addresses.
  • ltree - Provides data types for representing labels of data stored in a hierarchical tree-like structure.
  • orafce - Provides LightDB-A Database-specific Oracle SQL compatibility functions.
  • pageinspect - Provides functions for low level inspection of the contents of database pages; available to superusers only.
  • pg_trgm - Provides functions and operators for determining the similarity of alphanumeric text based on trigram matching. The module also provides index operator classes that support fast searching for similar strings.
  • pgcrypto - Provides cryptographic functions for LightDB-A Database.
  • postgres_fdw - Provides a foreign data wrapper (FDW) for accessing data stored in an external PostgreSQL or LightDB-A database.
  • postgresql-hll - Provides HyperLogLog data types for PostgreSQL and LightDB-A Database.
  • sslinfo - Provides information about the SSL certificate that the current client provided when connecting to LightDB-A.
  • timestamp9 - Provides an efficient nanosecond-precision timestamp data type for LightDB-A Database.
  • uuid-ossp - Provides functions to generate universally unique identifiers (UUIDs).