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;

Full catalog

Extension Type of extension Summary Command to create
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;
Audit Functions Audit user actions CREATE EXTENSION pgaudit;
Auto explain Logging Automatically log execution plans of slow statements See auto_explain
Auto Increment Functions Provides function for storing the next value of a sequence in an integer field CREATE EXTENSION autoinc;
Bloom Datatype Provides a bloom filter index type CREATE EXTENSION bloom;
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;
Buffer Cache Views Examine the shared buffer cache CREATE EXTENSION pg_buffercache;
Case insensitive text Datatype Case insensitive text datatype CREATE EXTENSION citext;
Cron Functions Create scheduled tasks CREATE EXTENSION pg_cron;
Cube Datatype Datatype for multi-dimensional cubes CREATE EXTENSION cube;
Dblink Functions Connect to other PostgreSQL databases from within a database CREATE EXTENSION dblink;
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;
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;
H3 Functions H3 bindings for Postgres CREATE EXTENSION h3;
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;
Hypopg Functions Hypothetical indexes CREATE EXTENSION hypopg;
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;
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;
Modification Time Functions Will place the current timestamp into a timestamp field CREATE EXTENSION moddatetime;
MySQL FDW Foreign Data Wrapper Foreign Data Wrapper for MySQL CREATE EXTENSION mysql_fdw;
Orafce Functions Emulate Oracle functions CREATE EXTENSION orafce;
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;
IVM Functions Incremental View Maintenance CREATE EXTENSION pg_ivm;
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;
Partman Functions Create and manage both time-based and serial-based table partition sets CREATE EXTENSION pg_partman;
Podman Functions Run containers inside the database See container apps
PostGIS Geospatial utilities PostGIS geometry, geography, and raster spatial types and functions See 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;
Postgres FDW Foreign Data Wrapper Foreign data wrapper for connecting to other Postgres databases CREATE EXTENSION postgres_fdw;
Prewarm Functions Utilities to prewarm your cache, helpful for standby failover CREATE EXTENSION pg_prewarm;
Proctab Functions Access operating system process tables from PostgreSQL CREATE EXTENSION pg_proctab;
Refint Functions Functions for referential integrity CREATE EXTENSION refint;
Routing Geospatial utilities Routing functionality CREATE EXTENSION pgrouting;
Similarity Functions Support for similarity queries CREATE EXTENSION pg_similarity;
Surgery Functions Corrective actions on corruption or damaged data CREATE EXTENSION pg_surgery;
Seg Datatype Datatype for representing floating point intervals or segments CREATE EXTENSION seg;
SSL Info Functions Ability to query SSL information based on who is CREATE EXTENSION sslinfo;
Stat statements Views Track planning and execution statistics of all SQL statements executed CREATE EXTENSION pg_stat_statements;
Table functions Functions Functions for cubing and rollups of tables CREATE EXTENSION tablefunc;
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;
Trigger change notifications Functions Functions for listening to changes on tables CREATE EXTENSION tcn;
Trigram Functions Matching and similarity of strings CREATE EXTENSION pg_trgm;
Unaccent Dictionaries Text search dictionary that removes accents CREATE EXTENSION unaccent;
Visibility Functions Examine the visibility map (VM) and page-level visibility info CREATE EXTENSION pg_visibility;
Vector Functions Vector data type and ivfflat access method CREATE EXTENSION vector;
uuid-ossp Functions Generate universally unique identifiers (UUIDs) CREATE EXTENSION uuid-ossp;
WAL inspect Functions Inspect contents of WAL CREATE EXTENSION pg_walinspect;
xml2 Functions XPath querying and XSLT CREATE EXTENSION xml2;

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: