Supported PostgreSQL Extensions

To add functionality to your PostgreSQL cluster, you can enable any of the following extensions using psql’s create extension command.

These extensions and versions are current as of the Validated date of this page.

If the extension you need is not on this list, you can suggest it to our product development team using ideas.digitalocean.com. If there’s an existing request for the extension, vote for it and we’ll notify you if we add it in the future. If not, add a new idea and choose Managed Databases as the product category.

Extension Name PostgreSQL 11 PostgreSQL 10 Description
address_standardizer 2.5.1 2.5.1 Used to parse an address into constituent elements. Generally used to support geocoding address normalization step.
address_standardizer_data_us 2.5.1 2.5.1 Address Standardizer US dataset example
btree_gin 1.2 1.2 support for indexing common datatypes in GIN
btree_gist 1.5 1.5 support for indexing common datatypes in GiST
chkpass 1 1 data type for auto-encrypted passwords
citext 1.4 1.4 data type for case-insensitive character strings
cube 1.2 1.2 data type for multidimensional cubes
dblink 1.2 1.2 connect to other PostgreSQL databases from within a database
dict_int 1 1 text search dictionary template for integers
earthdistance 1.1 1.1 calculate great-circle distances on the surface of the Earth
fuzzystrmatch 1.1 1.1 determine similarities and distance between strings
hstore 1.4 1.4 data type for storing sets of (key, value) pairs
insert_username 1 1 functions for tracking who changed a table
intagg 1.1 1.1 integer aggregator and enumerator (obsolete)
intarray 1.2 1.2 functions, operators, and index support for 1-D arrays of integers
isn 1.1 1.1 data types for international product numbering standards
ltree 1.1 1.1 data type for hierarchical tree-like structures
pg_buffercache 1.3 1.3 examine the shared buffer cache
pg_partman NOT SUPPORTED 3.1.3 Extension to manage partitioned tables by time or ID
pg_prometheus 0.2.1 0.2.1 Prometheus metrics for PostgreSQL
pg_repack 1.4.3 1.4.3 Reorganize tables in PostgreSQL databases with minimal locks
pg_stat_statements 1.6 1.6 track execution statistics of all SQL statements executed
pg_trgm 1.3 1.3 text similarity measurement and index searching based on trigrams
pgcrypto 1.3 1.3 cryptographic functions
pgrouting 2.6.1 2.6.1 pgRouting Extension
pgrowlocks 1.2 1.2 show row-level locking information
pgstattuple 1.5 1.5 show tuple-level statistics
plcoffee 1.4.4 1.4.4 PL/CoffeeScript (v8) trusted procedural language
plls 1.4.4 1.4.4 PL/LiveScript (v8) trusted procedural language
plperl 1 1 PL/Perl procedural language
plv8 1.4.4 1.4.4 PL/JavaScript (v8) trusted procedural language
postgis 2.5.1 2.5.1 PostGIS geometry, geography, and raster spatial types and functions
postgis_legacy 2.5 2.5 Legacy functions for PostGIS
postgis_sfcgal 2.5.1 2.5.1 PostGIS SFCGAL functions
postgis_tiger_geocoder 2.5.1 2.5.1 PostGIS tiger geocoder and reverse geocoder
postgis_topology 2.5.1 2.5.1 PostGIS topology spatial types and functions
postgres_fdw 1 1 foreign-data wrapper for remote PostgreSQL servers
sslinfo 1.2 1.2 information about SSL certificates
tablefunc 1 1 functions that manipulate whole tables, including crosstab
timescaledb 1.2.2 1.2.1 Enables scalable inserts and complex queries for time-series data
tsm_system_rows 1 1 TABLESAMPLE method which accepts number of rows as a limit
tsm_system_time 1 1 TABLESAMPLE method which accepts time in milliseconds as a limit
unaccent 1.1 1.1 text search dictionary that removes accents
unit 7 7 SI units extension
uuid-ossp 1.1 1.1 generate universally unique identifiers (UUIDs)