select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

PostgreSQL Extension Catalogue

Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.

earthdistance · calculate great-circle distances on the surface of the Earth · 1.2 · Geospatial · PostgreSQL · C · Packagedtsearch2 · Deprecated Amazon RDS PostgreSQL 10 compatibility extension for applications using pre-8.3 tsearch2 full-text-search APIs. · 1.0 · Full-text search · PostgreSQL · C · Not packagedfuzzystrmatch · determine similarities and distance between strings · 1.2 · Full-text search · PostgreSQL · C · Packagedpg_trgm · text similarity measurement and index searching based on trigrams · 1.6 · Full-text search · PostgreSQL · C · Packagedtablefunc · functions that manipulate whole tables, including crosstab · 1.0 · Analytics · PostgreSQL · C · Packagedpg_plan_advice · Describe and constrain planner choices with plan advice · Features · PostgreSQL · C · Not packagedbloom · bloom access method - signature file based index · 1.0 · Features · PostgreSQL · C · Packagedbool_plperl · transform between bool and plperl · 1.0 · Procedural languages · PostgreSQL · C · Packagedbool_plperlu · transform between bool and plperlu · 1.0 · Procedural languages · PostgreSQL · C · Packagedhstore_plperl · transform between hstore and plperl · 1.0 · Procedural languages · PostgreSQL · C · Packagedhstore_plperlu · transform between hstore and plperlu · 1.0 · Procedural languages · PostgreSQL · C · Packagedhstore_plpython3u · transform between hstore and plpython3u · 1.0 · Procedural languages · PostgreSQL · C · Packagedjsonb_plperl · transform between jsonb and plperl · 1.0 · Procedural languages · PostgreSQL · C · Packagedjsonb_plperlu · transform between jsonb and plperlu · 1.0 · Procedural languages · PostgreSQL · C · Packagedjsonb_plpython3u · transform between jsonb and plpython3u · 1.0 · Procedural languages · PostgreSQL · C · Packagedltree_plpython3u · transform between ltree and plpython3u · 1.0 · Procedural languages · PostgreSQL · C · Packagedplperl · PL/Perl procedural language · 1.0 · Procedural languages · PostgreSQL · C · Packagedplperlu · PL/PerlU untrusted procedural language · 1.0 · Procedural languages · PostgreSQL · C · Packagedplpgsql · PL/pgSQL procedural language · 1.0 · Procedural languages · PostgreSQL · C · Packagedplpython3u · PL/Python3U untrusted procedural language · 1.0 · Procedural languages · PostgreSQL · C · Packagedpltcl · PL/Tcl procedural language · 1.0 · Procedural languages · PostgreSQL · C · Packagedpltclu · PL/TclU untrusted procedural language · 1.0 · Procedural languages · PostgreSQL · C · Packagedcitext · data type for case-insensitive character strings · 1.6 · Data types · PostgreSQL · C · Packagedcube · data type for multidimensional cubes · 1.5 · Data types · PostgreSQL · C · Packagedhstore · data type for storing sets of (key, value) pairs · 1.8 · Data types · PostgreSQL · C · Packagedisn · data types for international product numbering standards · 1.2 · Data types · PostgreSQL · C · Packagedltree · data type for hierarchical tree-like structures · 1.3 · Data types · PostgreSQL · C · Packagedseg · data type for representing line segments or floating-point intervals · 1.4 · Data types · PostgreSQL · C · Packagedxml2 · XPath querying and XSLT · 1.1 · Data types · PostgreSQL · C · Packagedautoinc · functions for autoincrementing fields · 1.0 · Functions and aggregates · PostgreSQL · C · Packagedbtree_gin · support for indexing common datatypes in GIN · 1.3 · Functions and aggregates · PostgreSQL · C · Packagedbtree_gist · support for indexing common datatypes in GiST · 1.7 · Functions and aggregates · PostgreSQL · C · Packageddict_int · text search dictionary template for integers · 1.0 · Functions and aggregates · PostgreSQL · C · Packageddict_xsyn · text search dictionary template for extended synonym processing · 1.0 · Functions and aggregates · PostgreSQL · C · Packagedinsert_username · functions for tracking who changed a table · 1.0 · Functions and aggregates · PostgreSQL · C · Packagedintagg · integer aggregator and enumerator (obsolete) · 1.1 · Functions and aggregates · PostgreSQL · C · Packagedintarray · functions, operators, and index support for 1-D arrays of integers · 1.5 · Functions and aggregates · PostgreSQL · C · Packagedmoddatetime · functions for tracking last modification time · 1.0 · Functions and aggregates · PostgreSQL · C · Packagedrefint · functions for implementing referential integrity (obsolete) · 1.0 · Functions and aggregates · PostgreSQL · C · Packagedtcn · Triggered change notifications · 1.0 · Functions and aggregates · PostgreSQL · C · Packagedtsm_system_rows · TABLESAMPLE method which accepts number of rows as a limit · 1.0 · Functions and aggregates · PostgreSQL · C · Packagedtsm_system_time · TABLESAMPLE method which accepts time in milliseconds as a limit · 1.0 · Functions and aggregates · PostgreSQL · C · Packagedunaccent · text search dictionary that removes accents · 1.1 · Functions and aggregates · PostgreSQL · C · Packageduuid-ossp · generate universally unique identifiers (UUIDs) · 1.1 · Functions and aggregates · PostgreSQL · C · Packagedadminpack · administrative functions for PostgreSQL · 2.1 · Administration · PostgreSQL · C · Packagedamcheck · functions for verifying relation integrity · 1.4 · Administration · PostgreSQL · C · Packagedbasebackup_to_shell · adds a custom basebackup target called shell · - · Administration · PostgreSQL · C · Packagedbasic_archive · an example of an archive module · - · Administration · PostgreSQL · C · Packagedlo · Large Object maintenance · 1.1 · Administration · PostgreSQL · C · Packagedold_snapshot · utilities in support of old_snapshot_threshold · 1.0 · Administration · PostgreSQL · C · Packagedpg_prewarm · prewarm relation data · 1.2 · Administration · PostgreSQL · C · Packagedpg_stash_advice · Store plan advice by query ID and automatically apply it during PostgreSQL query planning · 1.0 · Administration · PostgreSQL · C · Not packagedpg_surgery · extension to perform surgery on a damaged relation · 1.0 · Administration · PostgreSQL · C · Packagedauto_explain · Provides a means for logging execution plans of slow statements automatically · - · Monitoring · PostgreSQL · C · Packagedpageinspect · inspect the contents of database pages at a low level · 1.12 · Monitoring · PostgreSQL · C · Packagedpg_buffercache · examine the shared buffer cache · 1.5 · Monitoring · PostgreSQL · C · Packagedpg_freespacemap · examine the free space map (FSM) · 1.2 · Monitoring · PostgreSQL · C · Packagedpg_logicalinspect · Logical decoding components inspection · 1.0 · Monitoring · PostgreSQL · C · Packagedpg_overexplain · Allow EXPLAIN to dump even more details · 1.0 · Monitoring · PostgreSQL · C · Packagedpg_stat_statements · track planning and execution statistics of all SQL statements executed · 1.11 · Monitoring · PostgreSQL · C · Packagedpg_visibility · examine the visibility map (VM) and page-level visibility info · 1.2 · Monitoring · PostgreSQL · C · Packagedpg_walinspect · functions to inspect contents of PostgreSQL Write-Ahead Log · 1.1 · Monitoring · PostgreSQL · C · Packagedpgrowlocks · show row-level locking information · 1.2 · Monitoring · PostgreSQL · C · Packagedpgstattuple · show tuple-level statistics · 1.5 · Monitoring · PostgreSQL · C · Packagedsslinfo · information about SSL certificates · 1.2 · Monitoring · PostgreSQL · C · Packagedauth_delay · pause briefly before reporting authentication failure · - · Security · PostgreSQL · C · Packagedpasswordcheck · checks user passwords and reject weak password · - · Security · PostgreSQL · C · Packagedpgcrypto · cryptographic functions · 1.3 · Security · PostgreSQL · C · Packagedsepgsql · label-based mandatory access control (MAC) based on SELinux security policy. · - · Security · PostgreSQL · C · Packageddblink · connect to other PostgreSQL databases from within a database · 1.2 · Foreign data wrappers · PostgreSQL · C · Packagedfile_fdw · foreign-data wrapper for flat file access · 1.0 · Foreign data wrappers · PostgreSQL · C · Packagedpostgres_fdw · foreign-data wrapper for remote PostgreSQL servers · 1.1 · Foreign data wrappers · PostgreSQL · C · Packagedpgoutput · Logical Replication output plugin · - · Replication and streams · PostgreSQL · C · Packagedtest_decoding · SQL-based test/example module for WAL logical decoding · - · Replication and streams · PostgreSQL · C · Packaged

74 extensions found. Clear filters

NameVersionDescriptionCategoryLicenseLanguagePG VersionStars
pg_plan_advice Describe and constrain planner choices with plan advice FEAT PostgreSQL C 19 22k
tsearch2 1.0 Deprecated Amazon RDS PostgreSQL 10 compatibility extension for applications using pre-8.3 tsearch2 full-text-search APIs. FTS PostgreSQL C 10 22k
adminpack 2.1 administrative functions for PostgreSQL ADMIN PostgreSQL C 14–16
amcheck 1.4 functions for verifying relation integrity ADMIN PostgreSQL C 14–18
auth_delay - pause briefly before reporting authentication failure SEC PostgreSQL C 14–18
auto_explain - Provides a means for logging execution plans of slow statements automatically STAT PostgreSQL C 14–18
autoinc 1.0 functions for autoincrementing fields FUNC PostgreSQL C 14–18
basebackup_to_shell - adds a custom basebackup target called shell ADMIN PostgreSQL C 15–18
basic_archive - an example of an archive module ADMIN PostgreSQL C 15–18
bloom 1.0 bloom access method - signature file based index FEAT PostgreSQL C 14–18
bool_plperl 1.0 transform between bool and plperl LANG PostgreSQL C 14–18
bool_plperlu 1.0 transform between bool and plperlu LANG PostgreSQL C 14–18
btree_gin 1.3 support for indexing common datatypes in GIN FUNC PostgreSQL C 14–18
btree_gist 1.7 support for indexing common datatypes in GiST FUNC PostgreSQL C 14–18
citext 1.6 data type for case-insensitive character strings TYPE PostgreSQL C 14–18
cube 1.5 data type for multidimensional cubes TYPE PostgreSQL C 14–18
dblink 1.2 connect to other PostgreSQL databases from within a database FDW PostgreSQL C 14–18
dict_int 1.0 text search dictionary template for integers FUNC PostgreSQL C 14–18
dict_xsyn 1.0 text search dictionary template for extended synonym processing FUNC PostgreSQL C 14–18
earthdistance 1.2 calculate great-circle distances on the surface of the Earth GIS PostgreSQL C 14–18
file_fdw 1.0 foreign-data wrapper for flat file access FDW PostgreSQL C 14–18
fuzzystrmatch 1.2 determine similarities and distance between strings FTS PostgreSQL C 14–18
hstore 1.8 data type for storing sets of (key, value) pairs TYPE PostgreSQL C 14–18
hstore_plperl 1.0 transform between hstore and plperl LANG PostgreSQL C 14–18
hstore_plperlu 1.0 transform between hstore and plperlu LANG PostgreSQL C 14–18
hstore_plpython3u 1.0 transform between hstore and plpython3u LANG PostgreSQL C 14–18
insert_username 1.0 functions for tracking who changed a table FUNC PostgreSQL C 14–18
intagg 1.1 integer aggregator and enumerator (obsolete) FUNC PostgreSQL C 14–18
intarray 1.5 functions, operators, and index support for 1-D arrays of integers FUNC PostgreSQL C 14–18
isn 1.2 data types for international product numbering standards TYPE PostgreSQL C 14–18
jsonb_plperl 1.0 transform between jsonb and plperl LANG PostgreSQL C 14–18
jsonb_plperlu 1.0 transform between jsonb and plperlu LANG PostgreSQL C 14–18
jsonb_plpython3u 1.0 transform between jsonb and plpython3u LANG PostgreSQL C 14–18
lo 1.1 Large Object maintenance ADMIN PostgreSQL C 14–18
ltree 1.3 data type for hierarchical tree-like structures TYPE PostgreSQL C 14–18
ltree_plpython3u 1.0 transform between ltree and plpython3u LANG PostgreSQL C 14–18
moddatetime 1.0 functions for tracking last modification time FUNC PostgreSQL C 14–18
old_snapshot 1.0 utilities in support of old_snapshot_threshold ADMIN PostgreSQL C 14–16
pageinspect 1.12 inspect the contents of database pages at a low level STAT PostgreSQL C 14–18
passwordcheck - checks user passwords and reject weak password SEC PostgreSQL C 14–18
pg_buffercache 1.5 examine the shared buffer cache STAT PostgreSQL C 14–18
pg_freespacemap 1.2 examine the free space map (FSM) STAT PostgreSQL C 14–18
pg_logicalinspect 1.0 Logical decoding components inspection STAT PostgreSQL C 18
pg_overexplain 1.0 Allow EXPLAIN to dump even more details STAT PostgreSQL C 18
pg_prewarm 1.2 prewarm relation data ADMIN PostgreSQL C 14–18
pg_stash_advice 1.0 Store plan advice by query ID and automatically apply it during PostgreSQL query planning ADMIN PostgreSQL C 19
pg_stat_statements 1.11 track planning and execution statistics of all SQL statements executed STAT PostgreSQL C 14–18
pg_surgery 1.0 extension to perform surgery on a damaged relation ADMIN PostgreSQL C 14–18
pg_trgm 1.6 text similarity measurement and index searching based on trigrams FTS PostgreSQL C 14–18
pg_visibility 1.2 examine the visibility map (VM) and page-level visibility info STAT PostgreSQL C 14–18