Supported Extensions

Extensions allow for expanded functionality within Postgres, without requiring a new version of Postgres to be released. Extensions can enable new functionality including datatypes and functions. Extensions can be enabled by running CREATE EXTENSION within the database as the postgres user.

You can see a list of all available extensions by querying within your database:

FROM pg_available_extensions

You can see all extensions that are already enabled by executing:

FROM pg_extension;

Extensions are enabled by running:

CREATE EXTENSION extensionname;

Supported extensions

Extension Type of extension Summary Command to create
Bloom Datatype Provides a bloom filter index type CREATE EXTENSION bloom;
Case insensitive text Datatype Case insensitive text datatype CREATE EXTENSION citext;
Cube Datatype Datatype for multi-dimensional cubes CREATE EXTENSION cube;
Hstore Datatype Key value datatype CREATE EXTENSION hstore;
Hstore (PL/Perl) Datatype Transform between Hstore and PL/Perl (trusted) CREATE EXTENSION hstore_plperl;
Hstore (PL/PerlU) Datatype Transform between Hstore and PL/PerlU (untrusted) CREATE EXTENSION hstore_plperlu;
Hstore (PL/Python3U) Datatype Transform between Hstore and PL/Python3U (untrusted) CREATE EXTENSION hstore_plpython3u;
ISN Datatype Datatype for product numbering (including UPC, ISBN, ISSN) CREATE EXTENSION isn;
JSONB (PL/Perl) Datatype Transform between JSONB and PL/Perl (trusted) CREATE EXTENSION jsonb_plperl;
JSONB (PL/PerlU) Datatype Transform between JSONB and PL/PerlU (untrusted) CREATE EXTENSION jsonb_plperlu;
JSONB (PL/Python3U) Datatype Transform between JSONB and PL/Python3U (untrusted) CREATE EXTENSION jsonb_plpython3u;
Large Object Datatype Specialized large object datatype CREATE EXTENSION lo;
Label Tree Datatype Datatype for tree-like structures CREATE EXTENSION ltree;
Label Tree (PL/Python3U) Datatype Transform between Ltree and PL/Python3U (untrusted) CREATE EXTENSION ltree_plpython3u;
Seg Datatype Datatype for representing floating point intervals or segments CREATE EXTENSION seg;
dict-int Dictionaries Full text search dictionary template for integers CREATE EXTENSION dict_int;
dict-xsyn Dictionaries Full text search dictionary template for extended synonym processing CREATE EXTENSION dict_xsyn;
unaccent Dictionaries Text search dictionary that removes accents CREATE EXTENSION unaccent;
Postgres FDW Foreign Data Wrapper Foreign data wrapper for connecting to other Postgres databases CREATE EXTENSION postgres_fdw;
Address Standardizer Functions Used to parse an address into constituent elements CREATE EXTENSION address_standardizer;
Address Standardizer (US) Functions Data for standardizing US addresses CREATE EXTENSION address_standardizer_data_us;
Adminpack Functions Administrative functions for Postgres CREATE EXTENSION adminpack;
Amcheck Functions Functions for verifying relation integrity CREATE EXTENSION amcheck;
Auto Increment Functions Provides function for storing the next value of a sequence in an integer field CREATE EXTENSION autoinc;
Dblink Functions Connect to other PostgreSQL databases from within a database CREATE EXTENSION dblink;
Earth Distance Functions Functions that assist with computing the distance between points. CREATE EXTENSION earthdistance;
Fuzzy String Match Functions Functions for comparing similarity between strings CREATE EXTENSION fuzzystrmatch;
Insert Username Functions Will place the current Postgres username in a text field CREATE EXTENSION insert_username;
Integer Aggregator Functions Integer aggregator and enumerator CREATE EXTENSION intagg;
Integer Array Functions Sorting and manipulation of integer arrays CREATE EXTENSION intarray;
Modification Time Functions Will place the current timestamp into a timestamp field CREATE EXTENSION moddatetime;
Page Inspect Functions Inspect the contents of database pages at a low level CREATE EXTENSION pageinspect;
PG Crypto Functions Functions for encrypting data inside columns CREATE EXTENSION pgcrypto;
Row Locking Functions Show row-level locking information CREATE EXTENSION pgrowlocks;
PG Stat Tuple Functions Show tuple-level statistics CREATE EXTENSION pgstattuple;
PG Free Space Map Functions Examine the free space map (FSM) CREATE EXTENSION pg_freespacemap;
pg_partman Functions Create and manage both time-based and serial-based table partition sets CREATE EXTENSION pg_partman;
PG prewarm Functions Utilities to prewarm your cache, helpful for standby failover CREATE EXTENSION pg_prewarm;
pg_proctab Functions Access operating system process tables from PostgreSQL CREATE EXTENSION pg_proctab;
pg_similarity Functions Support for similarity queries CREATE EXTENSION pg_similarity;
Trigram Functions Matching and similarity of strings CREATE EXTENSION pg_trgm;
pg_visibility Functions Examine the visibility map (VM) and page-level visibility info CREATE EXTENSION pg_visibility;
SSL Info Functions Ability to query SSL information based on who is CREATE EXTENSION sslinfo;
Table functions Functions Functions for cubing and rollups of tables CREATE EXTENSION tablefunc;
Trigger change notifications Functions Functions for listening to changes on tables CREATE EXTENSION tcn;
Table sampling (system rows) Functions Functions to provide sampling of system tables CREATE EXTENSION tsm_system_rows;
Table sampling (system time) Functions Functions to provide sampling of system time CREATE EXTENSION tsm_system_time;
uuid-ossp Functions Generate universally unique identifiers (UUIDs) CREATE EXTENSION uuid-ossp;
wal2json Functions Output plugin for logical decoding Pre-loaded
xml2 Functions XPath querying and XSLT CREATE EXTENSION xml2;
pgRouting Geospatial utilities Routing functionality CREATE EXTENSION pgrouting;
PostGIS Geospatial utilities PostGIS geometry, geography, and raster spatial types and functions CREATE EXTENSION postgis;
PostGIS Raster Geospatial utilities PostGIS raster types and functions CREATE EXTENSION postgis_raster;
PostGIS SFCGAL Geospatial utilities PostGIS SFCGAL functions CREATE EXTENSION postgis_sfcgal;
PostGIS Tiger Geocoder Geospatial utilities PostGIS tiger geocoder and reverse geocoder CREATE EXTENSION postgis_tiger_geocoder;
PostGIS Topology Geospatial utilities PostGIS topology spatial types and functions CREATE EXTENSION postgis_topology;
btree-gin Index types Support for indexing common datatypes in GIN CREATE EXTENSION btree_gin;
btree-gist Index types Support for indexing common datatypes in GiST CREATE EXTENSION btree_gist;
PG Buffer Cache Views Examine the shared buffer cache CREATE EXTENSION pg_buffercache;
pg_stat_statements Views Track planning and execution statistics of all SQL statements executed CREATE EXTENSION pg_stat_statements;

Procedural languages

While also a category of extension, procedural languages allow you to write custom functions to be executed within your database. Each of these has a number of additional details and functionality. We currently support: