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.

temporal_tables · temporal tables · 1.2.2 · Time series · BSD-2-Clause · C · Packagedgeoip · IP-based geolocation query · 0.3.0 · Geospatial · BSD-2-Clause · SQL · Packagedgeoip2lookup · Look up IP-address info in MaxMind GeoIP2 MMDB files · 0.0.3 · Geospatial · BSD-2-Clause · SQL · Not packagedpg_sentence_transformer · Runs a Hugging Face sentence-transformer model inside a preload background worker and maintains pgvector embeddings for a configured table. · 0.1 · AI and vectors · BSD-2-Clause · Python · Not packagedshared_ispell · Shared-memory ispell dictionary template for reducing per-session initialization and memory. · 1.0.0 · Full-text search · BSD-2-Clause · C · Not packagedpg_fusion · Experimental PostgreSQL extension for DataFusion-backed analytical query execution · 24.0.0 · Analytics · BSD-2-Clause · Rust · Not packagedschema_triggers · Archived C hook extension adding relation, column, and trigger schema-change events to PostgreSQL event triggers. · 0.1 · Features · BSD-2-Clause · C · Not packagedmeta_triggers · Insert, update and delete triggers for the meta system catalog · 0.5.0 · Features · BSD-2-Clause · SQL · Not packagedindex_analyzer · PL/pgSQL functions for evaluating existing and prospective indexes and checking foreign-key indexing. · 0.1.0 · Features · BSD-2-Clause · SQL · Not packagedtest_factory · Framework for registering, creating, caching, and reusing named PostgreSQL test data sets. · 0.5.0 · Features · BSD-2-Clause · SQL · Not packagedtest_factory_pgtap · A framework for managing test data · 0.1.0 · Features · BSD-2-Clause · SQL · Not packagedpg_regresql · Trust pg_class statistics for planning instead of physical relation size · 2.0.0 · Procedural languages · BSD-2-Clause · C · Packagedlambda · Lambda function for Postgres · 1.0.5 · Procedural languages · BSD-2-Clause · SQL · Not packagedacl · ACL Data type · 1.0.4 · Data types · BSD-2-Clause · C · Packagedpgbitmap · Bitmap-type extension for PostgreSQL · 0.9.5 · Data types · BSD-2-Clause · C · Not packagedmd5hash · type for storing 128-bit binary data inline · 1.0.1 · Data types · BSD-2-Clause · C · Packagedpostcode · Store UK postcodes in a compact 32-bit type with validation, formatting, partial matching, and B-tree indexing · 1.3.0 · Data types · BSD-2-Clause · C · Not packagedvariant · Variant data type that can store values from other PostgreSQL types. · 1.0.1 · Data types · BSD-2-Clause · C · Not packagedpg_acl · Utilities for handling aclitems. · 0.1.3 · Data types · BSD-2-Clause · SQL · Not packagedpguecc · uECC bindings for Postgres · 1.0 · Utilities · BSD-2-Clause · C · Packagedxxhash · xxhash functions for PostgreSQL · 0.0.1 · Utilities · BSD-2-Clause · C · Packagedbyteamagic · Detect MIME types and file formats from PostgreSQL bytea values · 0.2.4 · Utilities · BSD-2-Clause · C · Packagedreplace_empty_string · C trigger function that replaces empty strings with NULL · 1.0 · Utilities · BSD-2-Clause · C · Not packagedpgcurl · Calls curl/libcurl from PostgreSQL through a SQL function. · 0.0.1 · Utilities · BSD-2-Clause · C · Not packagedtrunklet-format · A format()-based template language for trunklet · 0.2.0 · Utilities · BSD-2-Clause · SQL · Not packagedcount_distinct · An alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate · 3.0.2 · Functions and aggregates · BSD-2-Clause · C · Packagedquantile · Quantile aggregation function · 1.1.8 · Functions and aggregates · BSD-2-Clause · C · Packagedhyperloglog_counter · Aggregation functions and data type for distinct estimation based on HyperLogLog. · 1.2.6 · Functions and aggregates · BSD-2-Clause · C · Not packagedloglog_counter · Aggregation functions and data type for distinct estimation based on LogLog. · 1.2.4 · Functions and aggregates · BSD-2-Clause · C · Not packagedpcsa_counter · Aggregation functions and data type for distinct estimation based on PCSA. · 1.3.3 · Functions and aggregates · BSD-2-Clause · C · Not packagedprobabilistic_counter · A C data type and aggregates for approximate distinct counting using the Flajolet-Martin probabilistic counting algorithm. · 1.3.3 · Functions and aggregates · BSD-2-Clause · C · Not packagedtrimmed_aggregates · C aggregate functions that discard configurable low/high outliers before computing averages, variances, and standard deviations. · 2.0.0-dev · Functions and aggregates · BSD-2-Clause · C · Not packagedpg_ta · TA-Lib technical-analysis functions exposed as PostgreSQL functions · 1.0 · Functions and aggregates · BSD-2-Clause · C · Not packagedpltoolbox · provide C utility functions for PostgreSQL stored procedures · 1.0.3 · Functions and aggregates · BSD-2-Clause · C · Not packagedcount_nulls · Count the number of null arguments · 0.9.6 · Functions and aggregates · BSD-2-Clause · SQL · Not packagedlower_quantile · Lower quantile aggregate function · 1.0.3 · Functions and aggregates · BSD-2-Clause · C · Packagedpg_squeeze · A tool to remove unused space from a relation. · 1.9.4 · Administration · BSD-2-Clause · C · Packagedpg_permissions · view object permissions and compare them with the desired state · 1.4.1 · Administration · BSD-2-Clause · SQL · Packagedpg_checksums · Activate/deactivate/verify checksums in offline Postgres clusters · 1.3 · Administration · BSD-2-Clause · C · Packagedconnection_limits · Enforce connection quotas by user, database, source IP or hostname, including combined rules. · 1.0.0 · Administration · BSD-2-Clause · C · Not packagedpg_connlimit · Limits per-role connection counts from filesystem configuration without catalog access. · 1.0 · Administration · BSD-2-Clause · C · Not packagedpg_profile · PostgreSQL load profile repository and report builder · 4.16 · Monitoring · BSD-2-Clause · C · Packagedmeta · Normalized, friendlier system catalog for PostgreSQL · 0.4.0 · Monitoring · BSD-2-Clause · SQL · Packagedquery_recorder · query_recorder: record executed SQL queries to rotating files for later analysis or replay · 1.0.1 · Monitoring · BSD-2-Clause · C · Not packagedpg_logfebe · log via febe framing protocol to a unix socket · 1.0 · Monitoring · BSD-2-Clause · C · Not packagedquery_histogram · Collects shared-memory histograms of statement and transaction runtimes through executor and utility hooks. · 1.1 · Monitoring · BSD-2-Clause · C · Not packagedpg_stat_usage · track usage statistics of stored procedure calls · 1.0 · Monitoring · BSD-2-Clause · C · Not packagedstreaminglag · SQL helpers that convert WAL LSNs to integers and estimate primary-to-standby streaming replication lag in bytes. · 1.0 · Monitoring · BSD-2-Clause · SQL · Not packagedpg_audit · An extension for creating audit tables · 0.1.3 · Security · BSD-2-Clause · SQL · Not packageduser_info · Provides user-related information including owned objects and granted roles. · 0.0.1 · Security · BSD-2-Clause · SQL · Not packagedr53db · r53db, the PostgreSQL Foreign Data Wrapper for the AWS Route53 Database service · 0.1 · Foreign data wrappers · BSD-2-Clause · C · Not packagedredis_link · Read-write PostgreSQL foreign data wrapper for Redis strings, hashes, and sets, with basic Redis Cluster support · 1.0 · Foreign data wrappers · BSD-2-Clause · C · Not packagedtemplate_fdw · Foreign data wrapper for template tables that intentionally rejects SELECT and DML operations. · 0.0 · Foreign data wrappers · BSD-2-Clause · C · Not packagedpg_sysdatetime · High-precision SQL Server-style system datetime functions for PostgreSQL, mainly useful on older Windows builds. · 1.0 · Compatibility · BSD-2-Clause · C · Not packagedpanda_post · Python Pandas data in Postgres · 0.2.1 · Replication and streams · BSD-2-Clause · Python · Not packagedpandapost · Python Pandas data in Postgres · 0.2.0 · Replication and streams · BSD-2-Clause · Python · Not packaged

56 extensions found. Clear filters

NameVersionDescriptionCategoryLicenseLanguagePG VersionStars
test_factory 0.5.0 Framework for registering, creating, caching, and reusing named PostgreSQL test data sets. FEAT BSD-2-Clause SQL 1
test_factory_pgtap 0.1.0 A framework for managing test data FEAT BSD-2-Clause SQL 1
trunklet-format 0.2.0 A format()-based template language for trunklet UTIL BSD-2-Clause SQL 1
user_info 0.0.1 Provides user-related information including owned objects and granted roles. SEC BSD-2-Clause SQL 1
lower_quantile 1.0.3 Lower quantile aggregate function FUNC BSD-2-Clause C 14–18
temporal_tables 1.2.2 temporal tables TIME BSD-2-Clause C 14–18