Contrib List

Available PostgreSQL Extension RPM in Debian / Ubuntu Distributions
Module:
Tags:

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

Last modified 2024-08-13: update extension meta data (323447b)