Contact UsGet started

Managing Greenplum® extensions

Written by
Updated at July 10, 2024

Managed Service for Greenplum® supports some Greenplum® extensions. For more information, refer to the full list of available extensions and their versions.

Retrieving a list of extensions available to install

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 Greenplum® documentation.

Supported Greenplum® extensions

Extension

Version

citext
Adds a data type to compare strings, case-insensitive.

1.0

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

1.1

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

1.0

fuzzystrmatch
Contains functions for identifying the similarity and distance between any two strings.

1.0

gp_internal_tools
Contains various internal utilities for Greenplum®.

1.0.0

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

1.3

pgcrypto
Adds data encryption functions. 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 System) objects to be stored and handled in PostgreSQL databases.

2.1.5

postgres_fdw
Adds a wrapper that allows you to access remote PostgreSQL databases.

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
Exports AO and AOCO tables from disks within the Managed Service for Greenplum® cluster to a cold storage in Yandex Object Storage. This way, the data will be stored in a service bucket in a compressed and encrypted form.

1.8

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

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