Yandex Cloud
Search
Contact UsTry it for free
  • Customer Stories
  • Documentation
  • Blog
  • All Services
  • System Status
    • Featured
    • Infrastructure & Network
    • Data Platform
    • Containers
    • Developer tools
    • Serverless
    • Security
    • Monitoring & Resources
    • AI for business
    • Business tools
  • All Solutions
    • By industry
    • By use case
    • Economics and Pricing
    • Security
    • Technical Support
    • Start testing with double trial credits
    • Cloud credits to scale your IT product
    • Gateway to Russia
    • Cloud for Startups
    • Center for Technologies and Society
    • Yandex Cloud Partner program
    • Price calculator
    • Pricing plans
  • Customer Stories
  • Documentation
  • Blog
© 2025 Direct Cursus Technology L.L.C.
Yandex MPP Analytics for PostgreSQL
  • Getting started
    • All guides
    • Connecting to an external file server (gpfdist)
      • Managing extensions
      • gp_url_tools
      • pgcrypto
      • uuid-cb
      • Yezzey
    • Auxiliary utilities
  • Access management
  • Pricing policy
  • Terraform reference
  • Monitoring metrics
  • Audit Trails events
  • Public materials
  • Release notes

In this article:

  • Retrieving a list of extensions available for installation
  • Retrieving a list of installed extensions
  • Editing a list of installed extensions
  • Supported Greenplum® extensions
  1. Step-by-step guides
  2. Greenplum® extensions
  3. Managing extensions

Managing Greenplum® extensions

Written by
Yandex Cloud
Updated at December 5, 2025
  • Retrieving a list of extensions available for installation
  • Retrieving a list of installed extensions
  • Editing a list of installed extensions
  • Supported Greenplum® extensions

Yandex MPP Analytics for PostgreSQL supports some Greenplum® extensions. See the full list of available extensions and their versions.

Retrieving a list of extensions available for installationRetrieving a list of extensions available for installation

Connect to the selected database and run this command:

SELECT * FROM pg_available_extensions();

This will display a list of DB extensions available for installation:

name                    | default_version | comment                            
------------------------+-----------------+------------------------------
 diskquota              | 1.0             | Disk Quota Main Program
...

Retrieving a list of installed extensionsRetrieving a list of installed extensions

Connect to the selected database and run this command:

SELECT extname FROM pg_extension;

This will display a list of extensions installed in the DB:

      extname
-------------------
 plpgsql
...

Editing a list of installed extensionsEditing a list of installed extensions

Connect to the selected database and run this command:

CREATE EXTENSION <extension_name>;

For more information, see this Greenplum® guide.

Supported Greenplum® extensionsSupported Greenplum® extensions

Extension

Version

citext
Adds a data type for case-insensitive string comparison.

1.0

dblink
Enables support for connections to other Greenplum® databases within a session.

1.1

diskquota
Allows limiting the of disk space for schemas and roles in a database.

1.0

fuzzystrmatch
Contains functions used to establish the degree of similarity and distance between any two strings.

1.0

gp_internal_tools
Contains various internal utilities for Greenplum®.

1.0.0

gp_url_tools
Contains functions for working with URLs. For more information, see Using gp_url_tools.

1.0

hstore
Adds a data type for storing key-value pairs in a single field.

1.3

pgcrypto
Adds data encryption features. For more information, see Using pgcrypto.

1.1

plperl
Enables support for the PL/Perl procedural language.

1.0

plpgsql
Enables support for the PL/pgSQL procedural language.

1.0

postgis
Enables storing and processing GIS (geographic information system) objects in PostgreSQL databases.

2.1.5

postgres_fdw
Adds a wrapper for queries against remote PostgreSQL databases.

1.0

pxf
Allows operating with heterogeneous data sources.

2.0

uuid-cb
Enables the generation and validation of unique IDs in compliance with the Russian Central Bank requirements. For more information, see Using uuid-cb.

1.0

Yezzey. Yandex Cloud extension

Enables moving AO and AOCO tables from cluster storage to cold storage and vice versa. To use this extension, enable hybrid storage in your Greenplum® cluster.

1.8

Greenplum® and Greenplum Database® are registered trademarks or trademarks of Broadcom Inc. in the United States and/or other countries.

Was the article helpful?

Previous
Connecting to an external file server (gpfdist)
Next
gp_url_tools
© 2025 Direct Cursus Technology L.L.C.