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.

documentdb · API surface for DocumentDB for PostgreSQL · 0.117-0 · Compatibility · MIT · C · Packageddocumentdb_core · Core API surface for DocumentDB on PostgreSQL · 0.117-0 · Compatibility · MIT · C · Packageddocumentdb_distributed · Multi-Node API surface for DocumentDB · 0.117-0 · Compatibility · MIT · C · Packageddocumentdb_extended_rum · DocumentDB Extended RUM index access method · 0.117-0 · Compatibility · MIT · C · Packagedpg_documentdb_gw_host · pg documentdb gw host: Created by pgrx · 0.1.0 · Compatibility · Unknown · Rust · Not packagedgb18030_2022 · Support GB18030-2022 and UTF-8 conversion · 1.0 · Compatibility · Apache-2.0 · C · Packagedivorysql_ora · Oracle Compatible extension on Postgres Database · 1.0 · Compatibility · Apache-2.0 · C · Packagedora_btree_gin · Support for indexing oracle datatypes in GIN · 1.0 · Compatibility · Apache-2.0 · C · Packagedora_btree_gist · Support for oracle indexing common datatypes in GiST · 1.0 · Compatibility · Apache-2.0 · C · Packagedpg_get_functiondef · Get function's definition · 1.0 · Compatibility · Apache-2.0 · C · Packagedplisql · PL/iSQL procedural language · 1.0 · Compatibility · Apache-2.0 · C · Packagedgms_raw · process raw type data for PL/SQL applications · 1.0 · Compatibility · MulanPSL-2.0 · C++ · Not packagedgms_tcp · provides TCP/IP client=side access functionality in PL/SQL · 1.1 · Compatibility · MulanPSL-2.0 · C++ · Not packagedorafce · Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS · 4.16.10 · Compatibility · 0BSD · C · Packagedoraplsql · Oracle-compatible procedural SQL language for OpenTenBase. · 1.0 · Compatibility · Unknown · C · Not packagedaux_mysql · MySQL Supplementary Extension · 1.5 · Compatibility · GPL-3.0 · C · Packagedpgmemcache · memcached interface · 2.3.0 · Compatibility · MIT · C · Packagedpgtt · Extension to add Global Temporary Tables feature to PostgreSQL · 4.6 · Compatibility · ISC · 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 · Packagedmysqlcompat · MySQL compatibility functions, aggregates, operators, and casts for PostgreSQL porting. · 0.0.7 · Compatibility · Unknown · SQL · Not packagedspat · Redis-like In-Memory DB Embedded in Postgres · 0.1.0a4 · Compatibility · AGPL-3.0 · C · Not packagedkafgres · Kafka protocol broker embedded in PostgreSQL · 0.1.0 · Compatibility · Elastic-2.0 · Rust · Packagedmonq · MongoDB-like query support for jsonb data · 0.1 · Compatibility · Unknown · C · Not packagedpgtt_rsl · Provide Oracle/DB2-style global temporary tables using unlogged tables, row-level security, views, and a cleanup worker · 2.0.0 · Compatibility · PostgreSQL · C · Not 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 · Packagedsession_variable · Registration and manipulation of session variables and constants · 3.4 · Compatibility · GPL-3.0 · C · Packagedomni_git · A PostgreSQL extension that stores git repositories in database tables and serves the git smart HTTP protocol, turning Postgres into a git remote. · 0.1.0 · Compatibility · MIT · C · Not packagedplpgsql_wrap · Oracle WRAP-equivalent PL/pgSQL language handler storing AES-256-GCM encrypted procedure source. · 1.0 · Compatibility · PostgreSQL · C · Packageddbms_sql · Implements a subset of Oracle's DBMS_SQL package API to ease application migration to PostgreSQL. · 1.0 · Compatibility · 0BSD · C · Not packagedpgorafunc · Oracle compatibility functions and packages for PostgreSQL · 9.4 · Compatibility · AGPL-3.0 · C · Not 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 · Packagedpg_utl_smtp · Oracle UTL_SMTP compatibility extension for PostgreSQL · 1.0.0 · Compatibility · PostgreSQL · SQL · 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 packagedorafce_mail · Implementation of utl mail and DBMS MAIL packages · 1.2 · Compatibility · PostgreSQL · C · Not packagedpgfirestore · Implements Firestore-style document values, collection queries, and query operators inside PostgreSQL. · 0.0.0 · Compatibility · Unknown · Rust · Not packagedpgs3 · S3-compatible object storage endpoint implemented inside PostgreSQL. · 0.1.1 · Compatibility · Apache-2.0 · Rust · Packagedbabelfishpg_common · SQL Server Transact SQL Datatype Support · 5.4.0 · Compatibility · Apache-2.0 · C · Packagedbabelfishpg_money · SQL Server Money Data Type · 1.1.0 · Compatibility · Apache-2.0 · C · Packagedbabelfishpg_tds · SQL Server TDS protocol extension · 1.0.0 · Compatibility · Apache-2.0 · C · Packagedbabelfishpg_tsql · SQL Server Transact SQL compatibility · 5.4.0 · Compatibility · Apache-2.0 · C · Packagediif · Adds iif function compatibility · 0.0.1 · Compatibility · BSD-3-Clause · C · Not packagedmdbqs · MongoDB-style query support for PostgreSQL · 0.1 · Compatibility · Unknown · C · Not packagednvlfunc · Oracle-compatible NVL function · 1.0 · Compatibility · Unknown · SQL · Not packagedpg_mysql · A PostgreSQL extension for launching MySQL servers from within PostgreSQL · 1.0 · Compatibility · Apache-2.0 · C · Not packagedpg_projection · MongoDB-like read projections for JSONB in PostgreSQL · 1.0.0 · Compatibility · MIT · SQL · Packagedpgkv · Redis-like key-value store for PostgreSQL using JSONB-backed PL/pgSQL functions · 0.1.0 · Compatibility · MIT · SQL · Not packagedshark · extension for D compatibility · 2.0 · Compatibility · MulanPSL-2.0 · C++ · Not packaged

50 extensions found. Clear filters

NameVersionDescriptionCategoryLicenseLanguagePG VersionStars
documentdb 0.117-0 API surface for DocumentDB for PostgreSQL SIM MIT C 15–18 3.4k
documentdb_core 0.117-0 Core API surface for DocumentDB on PostgreSQL SIM MIT C 15–18 3.4k
documentdb_distributed 0.117-0 Multi-Node API surface for DocumentDB SIM MIT C 15–18 3.4k
documentdb_extended_rum 0.117-0 DocumentDB Extended RUM index access method SIM MIT C 15–18 3.4k
pg_documentdb_gw_host 0.1.0 pg documentdb gw host: Created by pgrx SIM Rust 3.4k
gb18030_2022 1.0 Support GB18030-2022 and UTF-8 conversion SIM Apache-2.0 C 18 1.1k
ivorysql_ora 1.0 Oracle Compatible extension on Postgres Database SIM Apache-2.0 C 18 1.1k
ora_btree_gin 1.0 Support for indexing oracle datatypes in GIN SIM Apache-2.0 C 18 1.1k
ora_btree_gist 1.0 Support for oracle indexing common datatypes in GiST SIM Apache-2.0 C 18 1.1k
pg_get_functiondef 1.0 Get function's definition SIM Apache-2.0 C 18 1.1k
plisql 1.0 PL/iSQL procedural language SIM Apache-2.0 C 18 1.1k
gms_raw 1.0 process raw type data for PL/SQL applications SIM MulanPSL-2.0 C++ 784
gms_tcp 1.1 provides TCP/IP client=side access functionality in PL/SQL SIM MulanPSL-2.0 C++ 784
orafce 4.16.10 Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS SIM 0BSD C 14–18 541
oraplsql 1.0 Oracle-compatible procedural SQL language for OpenTenBase. SIM C 520
aux_mysql 1.5 MySQL Supplementary Extension SIM GPL-3.0 C 14 420
pgmemcache 2.3.0 memcached interface SIM MIT C 14–18 175
pgtt 4.6 Extension to add Global Temporary Tables feature to PostgreSQL SIM ISC C 14–18 99
pg_statement_rollback 1.6 Server side rollback at statement level for PostgreSQL like Oracle or DB2 SIM ISC C 14–18 56
pg_dbms_job 2.0 Extension to add Oracle DBMS_JOB full compatibility to PostgreSQL SIM PostgreSQL C 14–18 43
mysqlcompat 0.0.7 MySQL compatibility functions, aggregates, operators, and casts for PostgreSQL porting. SIM SQL 39
spat 0.1.0a4 Redis-like In-Memory DB Embedded in Postgres SIM AGPL-3.0 C 17 29
kafgres 0.1.0 Kafka protocol broker embedded in PostgreSQL SIM Elastic-2.0 Rust 16 19
monq 0.1 MongoDB-like query support for jsonb data SIM C 10–18 17
pgtt_rsl 2.0.0 Provide Oracle/DB2-style global temporary tables using unlogged tables, row-level security, views, and a cleanup worker SIM PostgreSQL C 10–18 17
pg_dbms_errlog 2.4 Emulate DBMS_ERRLOG Oracle module to log DML errors in a dedicated table. SIM ISC C 14–18 16
pg_dbms_metadata 1.0.0 Extension to add Oracle DBMS_METADATA compatibility to PostgreSQL SIM PostgreSQL SQL 14–18 13
session_variable 3.4 Registration and manipulation of session variables and constants SIM GPL-3.0 C 14–18 13
omni_git 0.1.0 A PostgreSQL extension that stores git repositories in database tables and serves the git smart HTTP protocol, turning Postgres into a git remote. SIM MIT C 11
plpgsql_wrap 1.0 Oracle WRAP-equivalent PL/pgSQL language handler storing AES-256-GCM encrypted procedure source. SIM PostgreSQL C 14–18 11
dbms_sql 1.0 Implements a subset of Oracle's DBMS_SQL package API to ease application migration to PostgreSQL. SIM 0BSD C 11–18 8
pgorafunc 9.4 Oracle compatibility functions and packages for PostgreSQL SIM AGPL-3.0 C 7
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_utl_smtp 1.0.0 Oracle UTL_SMTP compatibility extension for PostgreSQL SIM PostgreSQL SQL 14–18 6
pg_sysdatetime 1.0 High-precision SQL Server-style system datetime functions for PostgreSQL, mainly useful on older Windows builds. SIM BSD-2-Clause C 4
orafce_mail 1.2 Implementation of utl mail and DBMS MAIL packages SIM PostgreSQL C 1
pgfirestore 0.0.0 Implements Firestore-style document values, collection queries, and query operators inside PostgreSQL. SIM Rust 11–15 1
pgs3 0.1.1 S3-compatible object storage endpoint implemented inside PostgreSQL. SIM Apache-2.0 Rust 17–18 1
babelfishpg_common 5.4.0 SQL Server Transact SQL Datatype Support SIM Apache-2.0 C 17–18
babelfishpg_money 1.1.0 SQL Server Money Data Type SIM Apache-2.0 C 17–18
babelfishpg_tds 1.0.0 SQL Server TDS protocol extension SIM Apache-2.0 C 17–18
babelfishpg_tsql 5.4.0 SQL Server Transact SQL compatibility SIM Apache-2.0 C 17–18
iif 0.0.1 Adds iif function compatibility SIM BSD-3-Clause C
mdbqs 0.1 MongoDB-style query support for PostgreSQL SIM C
nvlfunc 1.0 Oracle-compatible NVL function SIM SQL
pg_mysql 1.0 A PostgreSQL extension for launching MySQL servers from within PostgreSQL SIM Apache-2.0 C
pg_projection 1.0.0 MongoDB-like read projections for JSONB in PostgreSQL SIM MIT SQL 14–18
pgkv 0.1.0 Redis-like key-value store for PostgreSQL using JSONB-backed PL/pgSQL functions SIM MIT SQL 12–18
shark 2.0 extension for D compatibility SIM MulanPSL-2.0 C++