Created
February 14, 2019 18:40
-
-
Save peterc/e4f7a288ed0eb7e4ffe2d8383a086306 to your computer and use it in GitHub Desktop.
Which Postgres extensions are available on DigitalOcean's new managed PostgreSQL service?
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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