SIM - Simulation & Compatibility

Protocol Simulation & heterogeneous DBMS Compatibility: Oracle, MSSQL, DB2, MySQL, Memcached, and Babelfish!

Extension List

There are 26 extensions in 15 packages.

ExtensionPackageVersionLicenseLanguageDescription
documentdbdocumentdb0.109MITCAPI surface for DocumentDB for PostgreSQL
documentdb_coredocumentdb0.109MITCCore API surface for DocumentDB for PostgreSQL
documentdb_distributeddocumentdb0.109MITCMulti-Node API surface for DocumentDB
documentdb_extended_rumdocumentdb0.109MITCDocumentDB Extended RUM index access method
orafceorafce4.16.5BSD 0-ClauseCFunctions and operators that emulate a subset of functions and packages from the Oracle RDBMS
pgttpgtt4.4ISCCExtension to add Global Temporary Tables feature to PostgreSQL
session_variablesession_variable3.4GPL-3.0CRegistration and manipulation of session variables and constants
pg_statement_rollbackpg_statement_rollback1.5ISCCServer side rollback at statement level for PostgreSQL like Oracle or DB2
ivorysql_oraivorysql1.0Apache-2.0COracle Compatible extension on Postgres Database
ora_btree_ginivorysql1.0Apache-2.0CSupport for indexing oracle datatypes in GIN
ora_btree_gistivorysql1.0Apache-2.0CSupport for oracle indexing common datatypes in GiST
pg_get_functiondefivorysql1.0Apache-2.0CGet function’s definition
plisqlivorysql1.0Apache-2.0CPL/iSQL procedural language
gb18030_2022ivorysql1.0Apache-2.0CSupport GB18030-2022 and UTF-8 conversion
pg_dbms_metadatapg_dbms_metadata1.0.0PostgreSQLSQLExtension to add Oracle DBMS_METADATA compatibility to PostgreSQL
pg_dbms_lockpg_dbms_lock1.0PostgreSQLSQLExtension to add Oracle DBMS_LOCK full compatibility to PostgreSQL
pg_dbms_jobpg_dbms_job1.5PostgreSQLSQLExtension to add Oracle DBMS_JOB full compatibility to PostgreSQL
pg_dbms_errlogpg_dbms_errlog2.2ISCCEmulate DBMS_ERRLOG Oracle module to log DML errors in a dedicated table.
pg_utl_smtppg_utl_smtp1.0.0PostgreSQLSQLOracle UTL_SMTP compatibility extension for PostgreSQL
babelfishpg_commonbabelfish5.5.0Apache-2.0CSQL Server Transact SQL Datatype Support
babelfishpg_tsqlbabelfish5.5.0Apache-2.0CSQL Server Transact SQL compatibility
babelfishpg_tdsbabelfish1.0.0Apache-2.0CSQL Server TDS protocol extension
babelfishpg_moneybabelfish1.1.0Apache-2.0CSQL Server Money Data Type
spatspat0.1.0a4AGPL-3.0CRedis-like In-Memory DB Embedded in Postgres
pgmemcachepgmemcache2.3.0MITCmemcached interface
aux_mysqlopenhalo1.5GPL-3.0CMySQL Supplementary Extension

documentdb

documentdb - 0.109 : API surface for DocumentDB for PostgreSQL

ItemValueOSx86_64aarch64
Extensiondocumentdbel818171615141817161514
Packagedocumentdbel918171615141817161514
RPMdocumentdb_$vel1018171615141817161514
DEBpostgresql-$v-documentdbd1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseMITu2418171615141817161514

documentdb_core

documentdb - 0.109 : Core API surface for DocumentDB for PostgreSQL

ItemValueOSx86_64aarch64
Extensiondocumentdb_coreel818171615141817161514
Packagedocumentdbel918171615141817161514
RPMdocumentdb_$vel1018171615141817161514
DEBpostgresql-$v-documentdbd1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseMITu2418171615141817161514

documentdb_distributed

documentdb - 0.109 : Multi-Node API surface for DocumentDB

ItemValueOSx86_64aarch64
Extensiondocumentdb_distributedel818171615141817161514
Packagedocumentdbel918171615141817161514
RPMdocumentdb_$vel1018171615141817161514
DEBpostgresql-$v-documentdbd1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseMITu2418171615141817161514

documentdb_extended_rum

documentdb - 0.109 : DocumentDB Extended RUM index access method

ItemValueOSx86_64aarch64
Extensiondocumentdb_extended_rumel818171615141817161514
Packagedocumentdbel918171615141817161514
RPMdocumentdb_$vel1018171615141817161514
DEBpostgresql-$v-documentdbd1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseMITu2418171615141817161514

orafce

orafce - 4.16.5 : Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS

ItemValueOSx86_64aarch64
Extensionorafceel818171615141817161514
Packageorafceel918171615141817161514
RPMorafce_$vel1018171615141817161514
DEBpostgresql-$v-orafced1218171615141817161514
LanguageCd1318171615141817161514
RepoPGDGu2218171615141817161514
LicenseBSD 0-Clauseu2418171615141817161514

pgtt

pgtt - 4.4 : Extension to add Global Temporary Tables feature to PostgreSQL

ItemValueOSx86_64aarch64
Extensionpgttel818171615141817161514
Packagepgttel918171615141817161514
RPMpgtt_$vel1018171615141817161514
DEBpostgresql-$v-pgttd1218171615141817161514
LanguageCd1318171615141817161514
RepoPGDGu2218171615141817161514
LicenseISCu2418171615141817161514

session_variable

session_variable - 3.4 : Registration and manipulation of session variables and constants

ItemValueOSx86_64aarch64
Extensionsession_variableel818171615141817161514
Packagesession_variableel918171615141817161514
RPMsession_variable_$vel1018171615141817161514
DEBpostgresql-$v-session-variabled1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseGPL-3.0u2418171615141817161514

pg_statement_rollback

pg_statement_rollback - 1.5 : Server side rollback at statement level for PostgreSQL like Oracle or DB2

ItemValueOSx86_64aarch64
Extensionpg_statement_rollbackel818171615141817161514
Packagepg_statement_rollbackel918171615141817161514
RPMpg_statement_rollback_$vel1018171615141817161514
DEBpostgresql-$v-pg-statement-rollbackd1218171615141817161514
LanguageCd1318171615141817161514
RepoMIXEDu2218171615141817161514
LicenseISCu2418171615141817161514

ivorysql_ora

ivorysql - 1.0 : Oracle Compatible extension on Postgres Database

ItemValueOSx86_64aarch64
Extensionivorysql_orael818171615141817161514
Packageivorysqlel918171615141817161514
RPMivorysql5el1018171615141817161514
DEBivorysql-5d1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseApache-2.0u2418171615141817161514

ora_btree_gin

ivorysql - 1.0 : Support for indexing oracle datatypes in GIN

ItemValueOSx86_64aarch64
Extensionora_btree_ginel818171615141817161514
Packageivorysqlel918171615141817161514
RPMivorysql5el1018171615141817161514
DEBivorysql-5d1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseApache-2.0u2418171615141817161514

ora_btree_gist

ivorysql - 1.0 : Support for oracle indexing common datatypes in GiST

ItemValueOSx86_64aarch64
Extensionora_btree_gistel818171615141817161514
Packageivorysqlel918171615141817161514
RPMivorysql5el1018171615141817161514
DEBivorysql-5d1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseApache-2.0u2418171615141817161514

pg_get_functiondef

ivorysql - 1.0 : Get function’s definition

ItemValueOSx86_64aarch64
Extensionpg_get_functiondefel818171615141817161514
Packageivorysqlel918171615141817161514
RPMivorysql5el1018171615141817161514
DEBivorysql-5d1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseApache-2.0u2418171615141817161514

plisql

ivorysql - 1.0 : PL/iSQL procedural language

ItemValueOSx86_64aarch64
Extensionplisqlel818171615141817161514
Packageivorysqlel918171615141817161514
RPMivorysql5el1018171615141817161514
DEBivorysql-5d1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseApache-2.0u2418171615141817161514

gb18030_2022

ivorysql - 1.0 : Support GB18030-2022 and UTF-8 conversion

ItemValueOSx86_64aarch64
Extensiongb18030_2022el818171615141817161514
Packageivorysqlel918171615141817161514
RPMivorysql5el1018171615141817161514
DEBivorysql-5d1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseApache-2.0u2418171615141817161514

pg_dbms_metadata

pg_dbms_metadata - 1.0.0 : Extension to add Oracle DBMS_METADATA compatibility to PostgreSQL

ItemValueOSx86_64aarch64
Extensionpg_dbms_metadatael818171615141817161514
Packagepg_dbms_metadatael918171615141817161514
RPMpg_dbms_metadata_$vel1018171615141817161514
DEB-d12--
LanguageSQLd13--
RepoPGDGu22--
LicensePostgreSQLu24--

pg_dbms_lock

pg_dbms_lock - 1.0 : Extension to add Oracle DBMS_LOCK full compatibility to PostgreSQL

ItemValueOSx86_64aarch64
Extensionpg_dbms_lockel818171615141817161514
Packagepg_dbms_lockel918171615141817161514
RPMpg_dbms_lock_$vel1018171615141817161514
DEB-d12--
LanguageSQLd13--
RepoPGDGu22--
LicensePostgreSQLu24--

pg_dbms_job

pg_dbms_job - 1.5 : Extension to add Oracle DBMS_JOB full compatibility to PostgreSQL

ItemValueOSx86_64aarch64
Extensionpg_dbms_jobel8--
Packagepg_dbms_jobel918171615141817161514
RPMpg_dbms_job_$vel1018171615141817161514
DEB-d12--
LanguageSQLd13--
RepoPGDGu22--
LicensePostgreSQLu24--

pg_dbms_errlog

pg_dbms_errlog - 2.2 : Emulate DBMS_ERRLOG Oracle module to log DML errors in a dedicated table.

ItemValueOSx86_64aarch64
Extensionpg_dbms_errlogel818171615141817161514
Packagepg_dbms_errlogel918171615141817161514
RPMpg_dbms_errlog_$vel1018171615141817161514
DEB-d12--
LanguageCd13--
RepoPGDGu22--
LicenseISCu24--

pg_utl_smtp

pg_utl_smtp - 1.0.0 : Oracle UTL_SMTP compatibility extension for PostgreSQL

ItemValueOSx86_64aarch64
Extensionpg_utl_smtpel818171615141817161514
Packagepg_utl_smtpel918171615141817161514
RPMpg_utl_smtp_$vel1018171615141817161514
DEBpostgresql-$v-utl-smtpd1218171615141817161514
LanguageSQLd1318171615141817161514
RepoPGDGu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

babelfishpg_common

babelfish - 5.5.0 : SQL Server Transact SQL Datatype Support

ItemValueOSx86_64aarch64
Extensionbabelfishpg_commonel818171615141817161514
Packagebabelfishel918171615141817161514
RPMbabelfish_$vel1018171615141817161514
DEBbabelfishpg-$v-babelfishd1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseApache-2.0u2418171615141817161514

babelfishpg_tsql

babelfish - 5.5.0 : SQL Server Transact SQL compatibility

ItemValueOSx86_64aarch64
Extensionbabelfishpg_tsqlel818171615141817161514
Packagebabelfishel918171615141817161514
RPMbabelfish_$vel1018171615141817161514
DEBbabelfishpg-$v-babelfishd1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseApache-2.0u2418171615141817161514

babelfishpg_tds

babelfish - 1.0.0 : SQL Server TDS protocol extension

ItemValueOSx86_64aarch64
Extensionbabelfishpg_tdsel818171615141817161514
Packagebabelfishel918171615141817161514
RPMbabelfish_$vel1018171615141817161514
DEBbabelfishpg-$v-babelfishd1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseApache-2.0u2418171615141817161514

babelfishpg_money

babelfish - 1.1.0 : SQL Server Money Data Type

ItemValueOSx86_64aarch64
Extensionbabelfishpg_moneyel818171615141817161514
Packagebabelfishel918171615141817161514
RPMbabelfish_$vel1018171615141817161514
DEBbabelfishpg-$v-babelfishd1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseApache-2.0u2418171615141817161514

spat

spat - 0.1.0a4 : Redis-like In-Memory DB Embedded in Postgres

ItemValueOSx86_64aarch64
Extensionspatel818171615141817161514
Packagespatel918171615141817161514
RPMspat_$vel10--
DEBpostgresql-$v-spatd1218171615141817161514
LanguageCd13--
RepoPIGSTYu2218171615141817161514
LicenseAGPL-3.0u2418171615141817161514

pgmemcache

pgmemcache - 2.3.0 : memcached interface

ItemValueOSx86_64aarch64
Extensionpgmemcacheel818171615141817161514
Packagepgmemcacheel918171615141817161514
RPMpgmemcache_$vel1018171615141817161514
DEBpostgresql-$v-pgmemcached1218171615141817161514
LanguageCd1318171615141817161514
RepoPGDGu2218171615141817161514
LicenseMITu2418171615141817161514

aux_mysql

openhalo - 1.5 : MySQL Supplementary Extension

ItemValueOSx86_64aarch64
Extensionaux_mysqlel818171615141817161514
Packageopenhaloel918171615141817161514
RPMopenhalodb_$vel1018171615141817161514
DEBopenhalodb-$vd1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseGPL-3.0u2418171615141817161514

Last Modified 2026-03-12: add pg extension catalog (95749bf)