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

3.3.2

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

-

ADB service → Install PostGIS action

address_standardizer_data_us

3.3.2

Provides sample rule tables for US address data

-

ADB service → Install PostGIS action

arenadata_toolkit

1.0

Used for manipulating the arenadata_toolkit schema and its objects

-

ADB service

btree_gin

1.3

Provides support for indexing common data types in GIN

-

 
CREATE EXTENSION btree_gin;

citext

1.6

Implements a data type for case-insensitive character strings

-

 
CREATE EXTENSION citext;

dblink

1.2

Supports connections to other PostgreSQL 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

file_fdw

1.0

Implements the foreign data wrapper for server-side flat files

-

 
CREATE EXTENSION file_fdw;

fuzzystrmatch

1.1

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

-

 
CREATE EXTENSION fuzzystrmatch;

gp_distribution_policy

1.0

Allows you to check distribution policies in a cluster

-

 
CREATE EXTENSION gp_distribution_policy;

gp_exttable_fdw

1.0

Converts an external table to a foreign table

-

 
CREATE EXTENSION gp_exttable_fdw;

gp_internal_tools

1.0.0

Provides different internal tools for Greengage DB

-

 
CREATE EXTENSION gp_internal_tools;

gp_legacy_string_agg

1.0.0

Implements the legacy single-argument function string_agg in Greengage DB

-

 
CREATE EXTENSION gp_legacy_string_agg;

gp_sparse_vector

1.0.1

Implements SParse vectors in Greengage DB

-

 
CREATE EXTENSION gp_sparse_vector;

gp_toolkit

1.8

Provides information from system catalogs, cluster logs, and environment status

-

 
CREATE EXTENSION gp_toolkit;

gpadcc

0.8

Used by the ADB Control service

+

ADB Control service

hstore

1.6

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

-

 
CREATE EXTENSION hstore;

isn

1.2

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.1

Implements a data type for hierarchical tree-like structures

-

 
CREATE EXTENSION ltree;

madlib

2.1.0

A scalable in-database analytics library

-

ADB service → Install MADlib action

orafce

4.9

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

-

 
CREATE EXTENSION orafce;

pageinspect

1.9

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

-

 
CREATE EXTENSION pageinspect;

pg_buffercache

1.4.1

Provides real-time access to the contents of the shared buffer cache

-

 
CREATE EXTENSION pg_buffercache;

pg_hint_plan

1.3.9

Allows controlling the query planner’s execution plan by using hints embedded in SQL comments

-

 
CREATE EXTENSION pg_hint_plan;

pg_stat_statements

1.7

Allows tracking planning and execution statistics of all SQL statements executed by a server

-

 
CREATE EXTENSION pg_stat_statements;

pg_trgm

1.4

Provides text similarity measurement and index searching based on trigram matching

-

 
CREATE EXTENSION pg_trgm;

pgcrypto

1.3

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

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

3.3.2

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

-

ADB service → Install PostGIS action

postgis_raster

3.3.2

Provides support for raster data

-

ADB service → Install PostGIS action

postgis_sfcgal

3.3.2

Implements PostGIS SFCGAL functions

-

ADB service → Install PostGIS action

postgis_tiger_geocoder

3.3.2

Provides the PostGIS TIGER geocoder and reverse geocoder

-

ADB service → Install PostGIS action

postgres_fdw

1.0

Implements a foreign data wrapper for remote PostgreSQL servers

-

 
CREATE EXTENSION postgres_fdw;

pxf

2.1

Allows you to access unmanaged data

-

PXF service → Install action

pxf_fdw

1.0

Implements a foreign data wrapper for PXF

-

PXF service → Install action

sslinfo

1.2

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.1

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