Contrib List

PostgreSQL built-in extension list
Module:
Tags:

The official site for all available extensions now moves to https://ext.pigsty.io

The latest PostgreSQL 16/17 comes with 70 Contrib extensions, from the PGDG repo under PostgreSQL license.

Name (URL) Alias Version Category PG Versions LOAD DDL DBSU RELOC Description
earthdistance earthdistance 1.1 GIS 17,16,15,14,13,12 calculate great-circle distances on the surface of the Earth
fuzzystrmatch fuzzystrmatch 1.2 FTS 17,16,15,14,13,12 determine similarities and distance between strings
pg_trgm pg_trgm 1.6 FTS 17,16,15,14,13,12 text similarity measurement and index searching based on trigrams
tablefunc tablefunc 1.0 OLAP 17,16,15,14,13,12 functions that manipulate whole tables, including crosstab
bloom bloom 1.0 FEAT 17,16,15,14,13,12 bloom access method - signature file based index
pltcl pltcl 1.0 LANG 17,16,15,14,13,12 PL/Tcl procedural language
pltclu pltcl 1.0 LANG 17,16,15,14,13,12 PL/TclU untrusted procedural language
plperl plperl 1.0 LANG 17,16,15,14,13,12 PL/Perl procedural language
bool_plperl plperl 1.0 LANG 17,16,15,14,13,12 transform between bool and plperl
hstore_plperl plperl 1.0 LANG 17,16,15,14,13,12 transform between hstore and plperl
jsonb_plperl plperl 1.0 LANG 17,16,15,14,13,12 transform between jsonb and plperl
plperlu plperlu 1.0 LANG 17,16,15,14,13,12 PL/PerlU untrusted procedural language
bool_plperlu plperlu 1.0 LANG 17,16,15,14,13,12 transform between bool and plperlu
jsonb_plperlu plperlu 1.0 LANG 17,16,15,14,13,12 transform between jsonb and plperlu
hstore_plperlu plperlu 1.0 LANG 17,16,15,14,13,12 transform between hstore and plperlu
plpgsql plpgsql 1.0 LANG 17,16,15,14,13,12 PL/pgSQL procedural language
plpython3u plpython3u 1.0 LANG 17,16,15,14,13,12 PL/Python3U untrusted procedural language
jsonb_plpython3u plpython3u 1.0 LANG 17,16,15,14,13,12 transform between jsonb and plpython3u
ltree_plpython3u plpython3u 1.0 LANG 17,16,15,14,13,12 transform between ltree and plpython3u
hstore_plpython3u plpython3u 1.0 LANG 17,16,15,14,13,12 transform between hstore and plpython3u
isn isn 1.2 TYPE 17,16,15,14,13,12 data types for international product numbering standards
seg seg 1.4 TYPE 17,16,15,14,13,12 data type for representing line segments or floating-point intervals
cube cube 1.5 TYPE 17,16,15,14,13,12 data type for multidimensional cubes
ltree ltree 1.2 TYPE 17,16,15,14,13,12 data type for hierarchical tree-like structures
hstore hstore 1.8 TYPE 17,16,15,14,13,12 data type for storing sets of (key, value) pairs
citext citext 1.6 TYPE 17,16,15,14,13,12 data type for case-insensitive character strings
xml2 xml2 1.1 TYPE 17,16,15,14,13,12 XPath querying and XSLT
refint refint 1.0 FUNC 17,16,15,14,13,12 functions for implementing referential integrity (obsolete)
autoinc autoinc 1.0 FUNC 17,16,15,14,13,12 functions for autoincrementing fields
insert_username insert_username 1.0 FUNC 17,16,15,14,13,12 functions for tracking who changed a table
moddatetime moddatetime 1.0 FUNC 17,16,15,14,13,12 functions for tracking last modification time
tsm_system_time tsm_system_time 1.0 FUNC 17,16,15,14,13,12 TABLESAMPLE method which accepts time in milliseconds as a limit
dict_xsyn dict_xsyn 1.0 FUNC 17,16,15,14,13,12 text search dictionary template for extended synonym processing
tsm_system_rows tsm_system_rows 1.0 FUNC 17,16,15,14,13,12 TABLESAMPLE method which accepts number of rows as a limit
tcn tcn 1.0 FUNC 17,16,15,14,13,12 Triggered change notifications
uuid-ossp uuid-ossp 1.1 FUNC 17,16,15,14,13,12 generate universally unique identifiers (UUIDs)
btree_gist btree_gist 1.7 FUNC 17,16,15,14,13,12 support for indexing common datatypes in GiST
btree_gin btree_gin 1.3 FUNC 17,16,15,14,13,12 support for indexing common datatypes in GIN
intarray intarray 1.5 FUNC 17,16,15,14,13,12 functions, operators, and index support for 1-D arrays of integers
intagg intagg 1.1 FUNC 17,16,15,14,13,12 integer aggregator and enumerator (obsolete)
dict_int dict_int 1.0 FUNC 17,16,15,14,13,12 text search dictionary template for integers
unaccent unaccent 1.1 FUNC 17,16,15,14,13,12 text search dictionary that removes accents
vacuumlo vacuumlo 16.3 ADMIN 17,16,15,14,13,12 utility program that will remove any orphaned large objects from a PostgreSQL database
pg_prewarm pg_prewarm 1.2 ADMIN 17,16,15,14,13,12 prewarm relation data
oid2name oid2name 16.3 ADMIN 17,16,15,14,13,12 utility program that helps administrators to examine the file structure used by PostgreSQL
lo lo 1.1 ADMIN 17,16,15,14,13,12 Large Object maintenance
basic_archive basic_archive 16.3 ADMIN 17,16,15 an example of an archive module
basebackup_to_shell basebackup_to_shell 16.3 ADMIN 17,16,15 adds a custom basebackup target called shell
old_snapshot old_snapshot 1.0 ADMIN 17,16,15,14 utilities in support of old_snapshot_threshold
adminpack adminpack 2.1 ADMIN 17,16,15,14,13,12 administrative functions for PostgreSQL
amcheck amcheck 1.3 ADMIN 17,16,15,14,13,12 functions for verifying relation integrity
pg_surgery pg_surgery 1.0 ADMIN 17,16,15,14 extension to perform surgery on a damaged relation
pageinspect pageinspect 1.12 STAT 17,16,15,14,13,12 inspect the contents of database pages at a low level
pgrowlocks pgrowlocks 1.2 STAT 17,16,15,14,13,12 show row-level locking information
sslinfo sslinfo 1.2 STAT 17,16,15,14,13,12 information about SSL certificates
pg_buffercache pg_buffercache 1.4 STAT 17,16,15,14,13,12 examine the shared buffer cache
pg_walinspect pg_walinspect 1.1 STAT 17,16,15 functions to inspect contents of PostgreSQL Write-Ahead Log
pg_freespacemap pg_freespacemap 1.2 STAT 17,16,15,14,13,12 examine the free space map (FSM)
pg_visibility pg_visibility 1.2 STAT 17,16,15,14,13,12 examine the visibility map (VM) and page-level visibility info
pgstattuple pgstattuple 1.5 STAT 17,16,15,14,13,12 show tuple-level statistics
auto_explain auto_explain 16.3 STAT 17,16,15,14,13,12 Provides a means for logging execution plans of slow statements automatically
pg_stat_statements pg_stat_statements 1.10 STAT 17,16,15,14,13,12 track planning and execution statistics of all SQL statements executed
sepgsql sepgsql 16.3 SEC 17,16,15,14,13,12 label-based mandatory access control (MAC) based on SELinux security policy.
auth_delay auth_delay 16.3 SEC 17,16,15,14,13,12 pause briefly before reporting authentication failure
pgcrypto pgcrypto 1.3 SEC 17,16,15,14,13,12 cryptographic functions
passwordcheck passwordcheck 16.3 SEC 17,16,15,14,13,12 checks user passwords and reject weak password
dblink dblink 1.2 FDW 17,16,15,14,13,12 connect to other PostgreSQL databases from within a database
file_fdw file_fdw 1.0 FDW 17,16,15,14,13,12 foreign-data wrapper for flat file access
postgres_fdw postgres_fdw 1.1 FDW 17,16,15,14,13,12 foreign-data wrapper for remote PostgreSQL servers
test_decoding test_decoding 16.3 ETL 17,16,15,14,13,12 SQL-based test/example module for WAL logical decoding

Last modified 2024-11-22: update docs (31c0995f)