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.

table_version · PostgreSQL table versioning extension · 1.11.1 · Time series · BSD-3-Clause · SQL · Packagedmobilitydb · MobilityDB geospatial trajectory data management & analysis platform · 1.3.0 · Geospatial · PostgreSQL · C · Packagedmobilitydb_datagen · MobilityDB random data generator functions · 1.3.0 · Geospatial · PostgreSQL · SQL · Packagedgeoip · IP-based geolocation query · 0.3.0 · Geospatial · BSD-2-Clause · SQL · Packagedpg_similarity · support similarity queries · 1.0 · AI and vectors · BSD-3-Clause · C · Packagedpg_bigm · create 2-gram (bigram) index for faster full text search. · 1.2 · Full-text search · PostgreSQL · C · Packagedplproxy · Database partitioning implemented as procedural language · 2.12.0 · Analytics · ISC · C · Packagedpg_fkpart · Table partitioning by foreign key utility · 1.7.0 · Analytics · GPL-2.0 · SQL · Packagedrdkit · Cheminformatics functionality for PostgreSQL. · 202503.6 · Features · BSD-3-Clause · C++ · Packagedpg_ivm · incremental view maintenance on PostgreSQL · 1.15 · Features · PostgreSQL · C · Packagedrum · RUM index access method · 1.3.15 · Features · PostgreSQL · C · Packagedpljs · PL/JS trusted procedural language · 1.0.5 · Procedural languages · PostgreSQL · C · Packagedhstore_pllua · Hstore transform for Lua · 2.0.12 · Procedural languages · MIT · C · Packagedhstore_plluau · Hstore transform for untrusted Lua · 2.0.12 · Procedural languages · MIT · C · Packagedpllua · Lua as a procedural language · 2.0.12 · Procedural languages · MIT · C · Packagedplluau · Lua as an untrusted procedural language · 2.0.12 · Procedural languages · MIT · C · Packagedfaker · Wrapper for the Faker Python library · 0.5.3 · Procedural languages · PostgreSQL · Python · Packageddbt2 · OSDL-DBT-2 test kit · 0.61.7 · Procedural languages · Artistic-2.0 · C · Packageduint · unsigned integer types · 1.20250815 · Data types · PostgreSQL · C · Packagedpg_rational · bigint fractions · 0.0.3 · Data types · MIT · C · Packagedpgfaceting · fast faceting queries using an inverted index · 0.2.0 · Data types · BSD-3-Clause · SQL · Packagedpg_rrule · RRULE field type for PostgreSQL · 0.3.0 · Data types · MIT · C · Packagedtimestamp9 · timestamp nanosecond resolution · 1.4.0 · Data types · MIT · C · Packagedpg_sphere · spherical objects with useful functions, operators and index support · 1.5.2 · Data types · BSD-3-Clause · C · Packagednumeral · numeral datatypes extension · 1.3 · Data types · GPL-2.0 · C · Packagedasn1oid · asn1oid extension · 1.6 · Data types · GPL-3.0 · C · Packagedgzip · gzip and gunzip functions. · 1.1.0 · Utilities · MIT · C · Packagedpgpcre · Perl Compatible Regular Expression functions · 0.20190509 · Utilities · PostgreSQL · C · Packagedpg_readme · Generate a Markdown README from PostgreSQL COMMENT objects · 0.7.1 · Utilities · PostgreSQL · SQL · Packagedpg_readme_test_extension · Fixture extension used to test pg_readme document generation · 0.7.1 · Utilities · PostgreSQL · SQL · Packagedpg_uuidv7 · Create UUIDv7 values in postgres · 1.7.0 · Functions and aggregates · MPL-2.0 · C · Packagedsequential_uuids · generator of sequential UUIDs · 1.0.3 · Functions and aggregates · MIT · C · Packagedcount_distinct · An alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate · 3.0.2 · Functions and aggregates · BSD-2-Clause · C · Packagedfirst_last_agg · first() and last() aggregate functions · 0.1.4 · Functions and aggregates · PostgreSQL · C · Packagedpg_csv · Flexible CSV processing for Postgres · 1.0.2 · Functions and aggregates · MIT · C · Packagedpg_dirtyread · Read dead but unvacuumed rows from table · 2.8 · Administration · BSD-3-Clause · C · Packagedddlx · DDL eXtractor functions · 0.31 · Administration · PostgreSQL · SQL · Packagedpg_rewrite · Tool allows read write to the table during the rewriting · 2.2 · Administration · BSD-3-Clause · C · Packagedpre_prepare · Pre Prepare your Statement server side · 0.9 · Administration · PostgreSQL · C · Packagedpg_readonly · cluster database read only · 1.0.6 · Administration · PostgreSQL · C · Packagedtable_log · record table modification logs and PITR for table/row · 0.6.4 · Administration · PostgreSQL · C · Packagedpg_profile · PostgreSQL load profile repository and report builder · 4.16 · Monitoring · BSD-2-Clause · C · Packagedpgsentinel · active session history · 1.4.2 · Monitoring · PostgreSQL · C · Packagedpg_wait_sampling · sampling based statistics of wait events · 1.1.11 · Monitoring · PostgreSQL · C · Packagedsystem_stats · EnterpriseDB system statistics for PostgreSQL · 4.1 · Monitoring · PostgreSQL · C · Packagedpg_store_plans · track plan statistics of all SQL statements executed · 1.10 · Monitoring · BSD-3-Clause · C · Packagedpgmeminfo · show memory usage · 1.0.0 · Monitoring · MIT · C · Packagedtoastinfo · show details on toasted datums · 1.7 · Monitoring · PostgreSQL · C · Packagedpg_jobmon · Extension for logging and monitoring functions in PostgreSQL · 1.4.1 · Security · PostgreSQL · SQL · Packagedlogerrors · Function for collecting statistics about messages in logfile · 2.1.5 · Security · BSD-3-Clause · C · Packagedlogin_hook · login_hook - hook to execute login_hook.login() at login time · 1.7 · Security · GPL-3.0 · C · Packagedpg_auth_mon · monitor connection attempts per user · 3.0 · Security · MIT · C · Packagedpg_snakeoil · The PostgreSQL Antivirus · 1.4 · Security · PostgreSQL · C · Packagedpasswordcheck_cracklib · Strengthen PostgreSQL user password checks with cracklib · 3.1.0 · Security · LGPL-2.1 · C · Packagedpgcryptokey · cryptographic key management · 0.85 · Security · PostgreSQL · C · Packagedhdfs_fdw · foreign-data wrapper for remote hdfs servers · 2.0.5 · Foreign data wrappers · PostgreSQL · C · Packagedjdbc_fdw · foreign-data wrapper for remote servers available over JDBC · 1.2 · Foreign data wrappers · PostgreSQL · C · Packagedpgbouncer_fdw · Extension for querying PgBouncer stats from normal SQL views & running pgbouncer commands from normal SQL functions · 1.4.0 · Foreign data wrappers · PostgreSQL · SQL · Packagedodbc_fdw · Foreign data wrapper for accessing remote databases using ODBC · 0.5.2 · Foreign data wrappers · PostgreSQL · C · Packagedpg_statement_rollback · Server side rollback at statement level for PostgreSQL like Oracle or DB2 · 1.6 · Compatibility · ISC · C · Packagedpg_dbms_job · Extension to add Oracle DBMS_JOB full compatibility to PostgreSQL · 2.0 · Compatibility · PostgreSQL · C · Packagedpg_dbms_errlog · Emulate DBMS_ERRLOG Oracle module to log DML errors in a dedicated table. · 2.4 · Compatibility · ISC · C · Packagedpg_dbms_metadata · Extension to add Oracle DBMS_METADATA compatibility to PostgreSQL · 1.0.0 · Compatibility · PostgreSQL · SQL · Packageddb2fce · DB2 compatibility functions, types, operators, and SYSIBM.SYSDUMMY1 for PostgreSQL. · 0.0.17 · Compatibility · PostgreSQL · SQL · Packagedpg_dbms_lock · Extension to add Oracle DBMS_LOCK full compatibility to PostgreSQL · 2.0 · Compatibility · PostgreSQL · SQL · Packagedmimeo · Extension for specialized, per-table replication between PostgreSQL instances · 1.5.1 · Replication and streams · PostgreSQL · SQL · Packaged

66 extensions found. Clear filters

NameVersionDescriptionCategoryLicenseLanguagePG VersionStars
pg_dbms_errlog 2.4 Emulate DBMS_ERRLOG Oracle module to log DML errors in a dedicated table. SIM ISC C 14–18 16
pgmeminfo 1.0.0 show memory usage STAT MIT C 14–18 15
pg_dbms_metadata 1.0.0 Extension to add Oracle DBMS_METADATA compatibility to PostgreSQL SIM PostgreSQL SQL 14–18 13
pg_readme 0.7.1 Generate a Markdown README from PostgreSQL COMMENT objects UTIL PostgreSQL SQL 14–18 13
pg_readme_test_extension 0.7.1 Fixture extension used to test pg_readme document generation UTIL PostgreSQL SQL 14–18 13
numeral 1.3 numeral datatypes extension TYPE GPL-2.0 C 14–18 11
dbt2 0.61.7 OSDL-DBT-2 test kit LANG Artistic-2.0 C 14–18 8
db2fce 0.0.17 DB2 compatibility functions, types, operators, and SYSIBM.SYSDUMMY1 for PostgreSQL. SIM PostgreSQL SQL 14–18 6
pg_dbms_lock 2.0 Extension to add Oracle DBMS_LOCK full compatibility to PostgreSQL SIM PostgreSQL SQL 14–18 6
pg_fkpart 1.7.0 Table partitioning by foreign key utility OLAP GPL-2.0 SQL 14–18 5
passwordcheck_cracklib 3.1.0 Strengthen PostgreSQL user password checks with cracklib SEC LGPL-2.1 C 14–18 4
toastinfo 1.7 show details on toasted datums STAT PostgreSQL C 14–18 3
asn1oid 1.6 asn1oid extension TYPE GPL-3.0 C 14–18 2
table_log 0.6.4 record table modification logs and PITR for table/row ADMIN PostgreSQL C 14–18 2
odbc_fdw 0.5.2 Foreign data wrapper for accessing remote databases using ODBC FDW PostgreSQL C 14–18 1
pgcryptokey 0.85 cryptographic key management SEC PostgreSQL C 14–18