Skip to content

Instantly share code, notes, and snippets.

@peterc
Created February 14, 2019 18:40
Show Gist options
  • Save peterc/e4f7a288ed0eb7e4ffe2d8383a086306 to your computer and use it in GitHub Desktop.
Save peterc/e4f7a288ed0eb7e4ffe2d8383a086306 to your computer and use it in GitHub Desktop.
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