Supported extensions

Daria Barysheva

Extensions are special modules that provide additional database functionality by bundling several SQL objects into a package to use them as a single unit. Extensions provide various functions, operators, data types, etc.

Below is a full list of extensions that are available in Arenadata DB.

Extension name Version Description Enterprise only Deployment type

adb_fdw

1.0

Implements a foreign data wrapper that provides two-way interaction between ADB clusters

ADB to ADB Connector

address_standardizer

2.5.4

Rule-based address standardizer that is used to parse an address into constituent elements

ADB service → Install PostGIS action

address_standardizer_data_us

2.5.4

Provides sample rule tables for US address data

ADB service → Install PostGIS action

amcheck

1.0

Implements functions for verifying relation integrity

CREATE EXTENSION amcheck;

arenadata_toolkit

1.3

Used for manipulating the arenadata_toolkit schema and its objects

ADB service

btree_gin

1.0

Provides support for indexing common data types in GIN

CREATE EXTENSION btree_gin;

btree_gist

1.0

Provides support for indexing common data types in GiST

CREATE EXTENSION btree_gist;

citext

1.0

Implements a data type for case-insensitive character strings

CREATE EXTENSION citext;

cube

1.0

Implements a data type for multidimensional cubes

CREATE EXTENSION cube;

dblink

1.1

Supports connections to other Greenplum databases from within a database session

ADB service

diskquota

2.3

Allows you to limit the amount of disk space used by schemas, roles, or tablespaces in a database

ADB service → Install diskquota action

fuzzystrmatch

1.0

Provides functions to determine similarities and distance (e.g. Levenshtein) between strings based on various algorithms

CREATE EXTENSION fuzzystrmatch;

gp_array_agg

1.0.0

Implements a parallel aggregate function in Greenplum

CREATE EXTENSION gp_array_agg;

gp_check_functions

1.1

Implements views and functions that can be used to manipulate missing and orphaned relation files

CREATE EXTENSION gp_check_functions;

gp_distribution_policy

1.0

Allows you to check distribution policies in a Greenplum cluster

CREATE EXTENSION gp_distribution_policy;

gp_internal_tools

1.0.0

Provides different internal tools for Greenplum

CREATE EXTENSION gp_internal_tools;

gp_legacy_string_agg

1.0.0

Implements the legacy single-argument function string_agg in Greenplum

CREATE EXTENSION gp_legacy_string_agg;

gp_parallel_retrieve_cursor

1.0

Implements a special kind of cursors that allow you to retrieve query results, on demand and in parallel, directly from the cluster segments

ADB to ADB Connector

gp_percentile_agg

1.0.0

Implements percentile aggregate functions in Greenplum

CREATE EXTENSION gp_percentile_agg;

gp_pitr

1.1

Provides distributed point-in-time-recovery functions

CREATE EXTENSION gp_pitr;

gp_sparse_vector

1.0.1

Implements SParse vectors in Greenplum

CREATE EXTENSION gp_sparse_vector;

gp_subtransaction_overflow

1.0.0

Used to get PIDs of overflowed subtransactions

CREATE EXTENSION gp_subtransaction_overflow;

gpadcc

0.5

Used by the ADB Control service

ADB Control service

gptkh

0.14

Used by the ADB ClickHouse Connector and Tkhemali services

Tkhemali/ADB ClickHouse Connector

hstore

1.3

Implements a data type for storing sets of key/value pairs within a single data field

CREATE EXTENSION hstore;

isn

1.0

Provides support for international product numbering standards

CREATE EXTENSION isn;

kadb_fdw

0.16

Implements a foreign data wrapper that provides interaction between Kafka and ADB

Kafka to ADB Connector

ltree

1.0

Implements a data type for hierarchical tree-like structures

CREATE EXTENSION ltree;

orafce

3.7

Implements SQL functions and operators that emulate a subset of functions and packages from the Oracle database

CREATE EXTENSION orafce;

pageinspect

1.8

Used to inspect the contents of database pages at a low level

CREATE EXTENSION pageinspect;

pg_partitions_nolock

1.0

Implements pg_partitions without locks

CREATE EXTENSION pg_partitions_nolock;

pg_trgm

1.1

Provides text similarity measurement and index searching based on trigram matching

CREATE EXTENSION pg_trgm;

pgcrypto

1.1

Implements cryptographic functions (encryption/decryption)

CREATE EXTENSION pgcrypto;

plperl

1.0

Provides support for PL/Perl procedural language

CREATE EXTENSION plperl;

plperlu

1.0

Provides support for PL/PerlU untrusted procedural language

CREATE EXTENSION plperlu;

plpgsql

1.0

Provides support for PL/pgSQL procedural language

ADB service

plpython2u

1.0

Provides support for PL/Python2U untrusted procedural language

CREATE EXTENSION plpython2u;

plpython3u

1.0

Provides support for PL/Python3U untrusted procedural language

CREATE EXTENSION plpython3u;

plpythonu

1.0

Provides support for PL/PythonU untrusted procedural language

CREATE EXTENSION plpythonu;

postgis

2.5.4

Provides PostGIS geometry, geography, and raster spatial types and functions

ADB service → Install PostGIS action

postgis_sfcgal

2.5.4

Implements PostGIS SFCGAL functions

ADB service → Install PostGIS action

postgis_tiger_geocoder

2.5.4

Provides the PostGIS TIGER geocoder and reverse geocoder

ADB service → Install PostGIS action

postgres_fdw

1.0

Implements a foreign data wrapper to access data that is stored in PostgreSQL or Greenplum remote databases

CREATE EXTENSION postgres_fdw;

pxf

2.1

Allows you to access unmanaged data

PXF service

sslinfo

1.0

Provides information about SSL certificates

CREATE EXTENSION sslinfo;

tablefunc

1.1

Provides functions that return tables (e.g. crosstab)

CREATE EXTENSION tablefunc;

tkh_fdw

1.0

Implements a foreign data wrapper that provides two-way interaction between ADB and ClickHouse

ADB ClickHouse Connector

uuid-ossp

1.0

Provides functions to generate universally unique identifiers (UUIDs)

CREATE EXTENSION uuid-ossp;

Found a mistake? Seleсt text and press Ctrl+Enter to report it