Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Which Postgres extensions are available on DigitalOcean's new managed PostgreSQL service?
defaultdb=> SELECT * FROM pg_available_extensions;
name | default_version | installed_version | comment
------------------------------+-----------------+-------------------+---------------------------------------------------------------------------------------------------------------------
aiven_extras | 1.0.2 | | aiven_extras
plpgsql | 1.0 | 1.0 | PL/pgSQL procedural language
btree_gist | 1.5 | | support for indexing common datatypes in GiST
tcn | 1.0 | | Triggered change notifications
seg | 1.3 | | data type for representing line segments or floating-point intervals
pgrowlocks | 1.2 | | show row-level locking information
plperlu | 1.0 | | PL/PerlU untrusted procedural language
ltree_plpython3u | 1.0 | | transform between ltree and plpython3u
pg_freespacemap | 1.2 | | examine the free space map (FSM)
intarray | 1.2 | | functions, operators, and index support for 1-D arrays of integers
hstore_plperlu | 1.0 | | transform between hstore and plperlu
lo | 1.1 | | Large Object maintenance
timetravel | 1.0 | | functions for implementing time travel
file_fdw | 1.0 | | foreign-data wrapper for flat file access
pg_visibility | 1.2 | | examine the visibility map (VM) and page-level visibility info
ltree_plpython2u | 1.0 | | transform between ltree and plpython2u
fuzzystrmatch | 1.1 | | determine similarities and distance between strings
hstore_plpython3u | 1.0 | | transform between hstore and plpython3u
pgcrypto | 1.3 | | cryptographic functions
tablefunc | 1.0 | | functions that manipulate whole tables, including crosstab
unaccent | 1.1 | | text search dictionary that removes accents
address_standardizer | 2.5.1 | | Used to parse an address into constituent elements. Generally used to support geocoding address normalization step.
pageinspect | 1.7 | | inspect the contents of database pages at a low level
postgis_legacy | 2.5 | | Legacy functions for PostGIS
tsm_system_time | 1.0 | | TABLESAMPLE method which accepts time in milliseconds as a limit
moddatetime | 1.0 | | functions for tracking last modification time
dict_int | 1.0 | | text search dictionary template for integers
amcheck | 1.1 | | functions for verifying relation integrity
postgis | 2.5.1 | | PostGIS geometry, geography, and raster spatial types and functions
pg_stat_statements | 1.6 | | track execution statistics of all SQL statements executed
sslinfo | 1.2 | | information about SSL certificates
hstore_plpython2u | 1.0 | | transform between hstore and plpython2u
postgis_topology | 2.5.1 | | PostGIS topology spatial types and functions
btree_gin | 1.3 | | support for indexing common datatypes in GIN
jsonb_plperlu | 1.0 | | transform between jsonb and plperlu
pgrouting | 2.6.1 | | pgRouting Extension
pg_buffercache | 1.3 | | examine the shared buffer cache
hstore_plpythonu | 1.0 | | transform between hstore and plpythonu
jsonb_plpython2u | 1.0 | | transform between jsonb and plpython2u
address_standardizer_data_us | 2.5.1 | | Address Standardizer US dataset example
pg_trgm | 1.4 | | text similarity measurement and index searching based on trigrams
postgis_tiger_geocoder | 2.5.1 | | PostGIS tiger geocoder and reverse geocoder
adminpack | 2.0 | | administrative functions for PostgreSQL
pg_prometheus | 0.2.1 | | Prometheus metrics for PostgreSQL
timescaledb | 1.2.0 | | Enables scalable inserts and complex queries for time-series data
cube | 1.4 | | data type for multidimensional cubes
pg_prewarm | 1.2 | | prewarm relation data
plperl | 1.0 | | PL/Perl procedural language
refint | 1.0 | | functions for implementing referential integrity (obsolete)
uuid-ossp | 1.1 | | generate universally unique identifiers (UUIDs)
isn | 1.2 | | data types for international product numbering standards
xml2 | 1.1 | | XPath querying and XSLT
insert_username | 1.0 | | functions for tracking who changed a table
hstore | 1.5 | | data type for storing sets of (key, value) pairs
ltree | 1.1 | | data type for hierarchical tree-like structures
earthdistance | 1.1 | | calculate great-circle distances on the surface of the Earth
dblink | 1.2 | | connect to other PostgreSQL databases from within a database
hstore_plperl | 1.0 | | transform between hstore and plperl
dict_xsyn | 1.0 | | text search dictionary template for extended synonym processing
tsm_system_rows | 1.0 | | TABLESAMPLE method which accepts number of rows as a limit
pg_repack | 1.4.4 | | Reorganize tables in PostgreSQL databases with minimal locks
autoinc | 1.0 | | functions for autoincrementing fields
jsonb_plpythonu | 1.0 | | transform between jsonb and plpythonu
ltree_plpythonu | 1.0 | | transform between ltree and plpythonu
jsonb_plpython3u | 1.0 | | transform between jsonb and plpython3u
bloom | 1.0 | | bloom access method - signature file based index
intagg | 1.1 | | integer aggregator and enumerator (obsolete)
pgstattuple | 1.5 | | show tuple-level statistics
citext | 1.5 | | data type for case-insensitive character strings
postgres_fdw | 1.0 | | foreign-data wrapper for remote PostgreSQL servers
postgis_sfcgal | 2.5.1 | | PostGIS SFCGAL functions
jsonb_plperl | 1.0 | | transform between jsonb and plperl
(72 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.