Contact UsGet started
© 2025 Direct Cursus Technology L.L.C.

Managing Greenplum® extensions

Written by
Updated at May 22, 2025

Managed Service for Greenplum® supports some Greenplum® extensions. See the full list of available extensions and their versions.

Retrieving a list of extensions available for installation

Connect to the selected database and run:

SELECT * FROM pg_available_extensions();

This will display a list of DB extensions available to install:

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

Retrieving a list of installed extensions

Connect to the selected database and run:

SELECT extname FROM pg_extension;

A list of extensions installed in the DB is displayed:

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

Editing a list of installed extensions

Connect to the selected database and run:

CREATE EXTENSION <extension_name>;

For more information, see the relevant Greenplum® documentation.

Supported 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 size 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 gp_url_tools usage.

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
Allows GIS (Geographic Information Systems) objects to be stored and processed in PostgreSQL databases.

2.1.5

postgres_fdw
Adds a wrapper for PostgreSQL remote database queries.

1.0

pxf
Allows you to work 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

Allows you to move AO and AOCO tables from the cluster storage to a cold storage and vice versa. To use this extension, enable hybrid storage in your Managed Service for Greenplum® cluster.

1.8

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

Previous
Connecting to an external file server (gpfdist)
Next
gp_url_tools