Extensions
Available and installed extensions
Available and installed extensions
| Name | Default version | Installed version | Comment |
|---|---|---|---|
| plpgsql | 1.0 | 1.0 | PL/pgSQL procedural language |
| bloom | 1.0 | bloom access method - signature file based index | |
| ltree_plpython3u | 1.0 | transform between ltree and plpython3u | |
| autoinc | 1.0 | functions for autoincrementing fields | |
| postgres_fdw | 1.0 | foreign-data wrapper for remote PostgreSQL servers | |
| hstore_plpython3u | 1.0 | transform between hstore and plpython3u | |
| tablefunc | 1.0 | functions that manipulate whole tables, including crosstab | |
| jsonb_plpython3u | 1.0 | transform between jsonb and plpython3u | |
| tsm_system_time | 1.0 | TABLESAMPLE method which accepts time in milliseconds as a limit | |
| refint | 1.0 | functions for implementing referential integrity (obsolete) | |
| moddatetime | 1.0 | functions for tracking last modification time | |
| tcn | 1.0 | Triggered change notifications | |
| insert_username | 1.0 | functions for tracking who changed a table | |
| dict_int | 1.0 | text search dictionary template for integers | |
| file_fdw | 1.0 | foreign-data wrapper for flat file access | |
| plpython3u | 1.0 | PL/Python3U untrusted procedural language | |
| dict_xsyn | 1.0 | text search dictionary template for extended synonym processing | |
| timetravel | 1.0 | functions for implementing time travel | |
| tsm_system_rows | 1.0 | TABLESAMPLE method which accepts number of rows as a limit | |
| xml2 | 1.1 | XPath querying and XSLT | |
| amcheck | 1.1 | functions for verifying relation integrity | |
| unaccent | 1.1 | text search dictionary that removes accents | |
| ltree | 1.1 | data type for hierarchical tree-like structures | |
| intagg | 1.1 | integer aggregator and enumerator (obsolete) | |
| uuid-ossp | 1.1 | generate universally unique identifiers (UUIDs) | |
| lo | 1.1 | Large Object maintenance | |
| fuzzystrmatch | 1.1 | determine similarities and distance between strings | |
| earthdistance | 1.1 | calculate great-circle distances on the surface of the Earth | |
| intarray | 1.2 | functions, operators, and index support for 1-D arrays of integers | |
| pg_visibility | 1.2 | examine the visibility map (VM) and page-level visibility info | |
| pg_prewarm | 1.2 | prewarm relation data | |
| pgrowlocks | 1.2 | show row-level locking information | |
| sslinfo | 1.2 | information about SSL certificates | |
| pg_freespacemap | 1.2 | examine the free space map (FSM) | |
| dblink | 1.2 | connect to other PostgreSQL databases from within a database | |
| isn | 1.2 | data types for international product numbering standards | |
| seg | 1.3 | data type for representing line segments or floating-point intervals | |
| btree_gin | 1.3 | support for indexing common datatypes in GIN | |
| pgcrypto | 1.3 | cryptographic functions | |
| pg_buffercache | 1.3 | examine the shared buffer cache | |
| cube | 1.4 | data type for multidimensional cubes | |
| pg_trgm | 1.4 | text similarity measurement and index searching based on trigrams | |
| hstore | 1.5 | data type for storing sets of (key, value) pairs | |
| btree_gist | 1.5 | support for indexing common datatypes in GiST | |
| pgstattuple | 1.5 | show tuple-level statistics | |
| citext | 1.5 | data type for case-insensitive character strings | |
| pg_stat_statements | 1.6 | 1.6 | track execution statistics of all SQL statements executed |
| pageinspect | 1.7 | inspect the contents of database pages at a low level | |
| adminpack | 2.0 | administrative functions for PostgreSQL | |
| timescaledb | 2.3.1 | Enables scalable inserts and complex queries for time-series data | |
| pgagent | 4.0 | A PostgreSQL job scheduler |