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_walinspect 1.1 functions to inspect contents of PostgreSQL Write-Ahead Log STAT PostgreSQL C 15–18
pgcrypto 1.3 cryptographic functions SEC PostgreSQL C 14–18
pgoutput - Logical Replication output plugin ETL PostgreSQL C 14–18
pgrowlocks 1.2 show row-level locking information STAT PostgreSQL C 14–18
pgstattuple 1.5 show tuple-level statistics STAT PostgreSQL C 14–18
plperl 1.0 PL/Perl procedural language LANG PostgreSQL C 14–18
plperlu 1.0 PL/PerlU untrusted procedural language LANG PostgreSQL C 14–18
plpgsql 1.0 PL/pgSQL procedural language LANG PostgreSQL C 14–18
plpython3u 1.0 PL/Python3U untrusted procedural language LANG PostgreSQL C 14–18
pltcl 1.0 PL/Tcl procedural language LANG PostgreSQL C 14–18
pltclu 1.0 PL/TclU untrusted procedural language LANG PostgreSQL C 14–18
postgres_fdw 1.1 foreign-data wrapper for remote PostgreSQL servers FDW PostgreSQL C 14–18
refint 1.0 functions for implementing referential integrity (obsolete) FUNC PostgreSQL C 14–18
seg 1.4 data type for representing line segments or floating-point intervals TYPE PostgreSQL C 14–18
sepgsql - label-based mandatory access control (MAC) based on SELinux security policy. SEC PostgreSQL C 14–18
sslinfo 1.2 information about SSL certificates STAT PostgreSQL C 14–18
tablefunc 1.0 functions that manipulate whole tables, including crosstab OLAP PostgreSQL C 14–18
tcn 1.0 Triggered change notifications FUNC PostgreSQL C 14–18
test_decoding - SQL-based test/example module for WAL logical decoding ETL PostgreSQL C 14–18
tsm_system_rows 1.0 TABLESAMPLE method which accepts number of rows as a limit FUNC PostgreSQL C 14–18
tsm_system_time 1.0 TABLESAMPLE method which accepts time in milliseconds as a limit FUNC PostgreSQL C 14–18
unaccent 1.1 text search dictionary that removes accents FUNC PostgreSQL C 14–18
uuid-ossp 1.1 generate universally unique identifiers (UUIDs) FUNC PostgreSQL C 14–18
xml2 1.1 XPath querying and XSLT TYPE PostgreSQL C 14–18