This is the multi-page printable view of this section. Click here to print.

Return to the regular view of this page.

Category: SIM

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

SIM category has 12 available extensions:

Extension (URL) Alias Repo Version Category License LOAD DDL TRUST RELOC Description
orafce orafce PGDG 4.13 SIM BSD 0 Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS
pgtt pgtt PGDG 4.0.0 SIM ISC Extension to add Global Temporary Tables feature to PostgreSQL
session_variable session_variable PIGSTY 3.4 SIM GPLv3 Registration and manipulation of session variables and constants
pg_statement_rollback pg_statement_rollback PGDG 1.4 SIM ISC Server side rollback at statement level for PostgreSQL like Oracle or DB2
pg_dbms_metadata pg_dbms_metadata PGDG 1.0.0 SIM PostgreSQL Extension to add Oracle DBMS_METADATA compatibility to PostgreSQL
pg_dbms_lock pg_dbms_lock PGDG 1.0.0 SIM PostgreSQL Extension to add Oracle DBMS_LOCK full compatibility to PostgreSQL
pg_dbms_job pg_dbms_job PGDG 1.5.0 SIM PostgreSQL Extension to add Oracle DBMS_JOB full compatibility to PostgreSQL
babelfishpg_common babelfishpg_common WILTON 3.3.3 SIM Apache-2.0 SQL Server Transact SQL Datatype Support
babelfishpg_tsql babelfishpg_tsql WILTON 3.3.1 SIM Apache-2.0 SQL Server Transact SQL compatibility
babelfishpg_tds babelfishpg_tds WILTON 1.0.0 SIM Apache-2.0 SQL Server TDS protocol extension
babelfishpg_money babelfishpg_money WILTON 1.1.0 SIM Apache-2.0 SQL Server Money Data Type
pgmemcache pgmemcache PGDG 2.3.0 SIM MIT memcached interface

1 - mysqlcompat

MySQL compatibility functions

Overview

PIGSTY 3rd Party Extension: mysqlcompat : MySQL compatibility functions

Information

Metadata

  • Version: 0.0.7
  • PG Vers: 16,15
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: mysqlcompat_$v*
  • RPM Ver : 0.0.7
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-mysqlcompat
  • DEB Ver : 0.0.7
  • DEB Deps: Nil

Details

2 - orafce

Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS

Overview

PGDG 1st Party Extension: orafce : Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS

Information

Metadata

  • Version: 4.13
  • PG Vers: 17,16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PGDG
  • RPM Name: orafce_$v*
  • RPM Ver : 4.13
  • RPM Deps: Nil
  • DEB Repo: PGDG
  • DEB Name: postgresql-$v-orafce
  • DEB Ver : 4.13
  • DEB Deps: Nil

Details

3 - pgtt

Extension to add Global Temporary Tables feature to PostgreSQL

Overview

PGDG 1st Party Extension: pgtt : Extension to add Global Temporary Tables feature to PostgreSQL

Information

Metadata

  • Version: 4.0.0
  • PG Vers: 17,16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PGDG
  • RPM Name: pgtt_$v*
  • RPM Ver : 4.0.0
  • RPM Deps: Nil
  • DEB Repo: PGDG
  • DEB Name: postgresql-$v-pgtt
  • DEB Ver : 4.0.0
  • DEB Deps: Nil

Details

4 - session_variable

Registration and manipulation of session variables and constants

Overview

PIGSTY 3rd Party Extension: session_variable : Registration and manipulation of session variables and constants

Information

Metadata

  • Version: 3.4
  • PG Vers: 17,16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Unknown
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: session_variable_$v*
  • RPM Ver : 3.4
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-session-variable
  • DEB Ver : 3.4
  • DEB Deps: Nil

Details

5 - pg_statement_rollback

Server side rollback at statement level for PostgreSQL like Oracle or DB2

Overview

PGDG 3rd Party Extension: pg_statement_rollback : Server side rollback at statement level for PostgreSQL like Oracle or DB2

Information

Metadata

  • Version: 1.4
  • PG Vers: 17,16,15,14,13,12
  • Need Load: Explicit Loading Required
  • Need DDL: DO NOT CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PGDG
  • RPM Name: pg_statement_rollback_$v*
  • RPM Ver : 1.4
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-pg-statement-rollback
  • DEB Ver : 1.4
  • DEB Deps: Nil

Details

6 - pg_dbms_metadata

Extension to add Oracle DBMS_METADATA compatibility to PostgreSQL

Overview

PGDG 1st Party Extension: pg_dbms_metadata : Extension to add Oracle DBMS_METADATA compatibility to PostgreSQL

Information

Metadata

  • Version: 1.0.0
  • PG Vers: 17,16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PGDG
  • RPM Name: pg_dbms_metadata_$v*
  • RPM Ver : 1.0.0
  • RPM Deps: Nil
  • DEB Repo: N/A
  • DEB Name: N/A
  • DEB Ver : N/A
  • DEB Deps: Nil

Details

7 - pg_dbms_lock

Extension to add Oracle DBMS_LOCK full compatibility to PostgreSQL

Overview

PGDG 1st Party Extension: pg_dbms_lock : Extension to add Oracle DBMS_LOCK full compatibility to PostgreSQL

Information

Metadata

  • Version: 1.0.0
  • PG Vers: 17,16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PGDG
  • RPM Name: pg_dbms_lock_$v*
  • RPM Ver : 1.0.0
  • RPM Deps: Nil
  • DEB Repo: N/A
  • DEB Name: N/A
  • DEB Ver : N/A
  • DEB Deps: Nil

Details

8 - pg_dbms_job

Extension to add Oracle DBMS_JOB full compatibility to PostgreSQL

Overview

PGDG 1st Party Extension: pg_dbms_job : Extension to add Oracle DBMS_JOB full compatibility to PostgreSQL

Information

Metadata

  • Version: 1.5.0
  • PG Vers: 17,16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PGDG
  • RPM Name: pg_dbms_job_$v*
  • RPM Ver : 1.5.0
  • RPM Deps: Nil
  • DEB Repo: N/A
  • DEB Name: N/A
  • DEB Ver : N/A
  • DEB Deps: Nil

Details

9 - babelfishpg_common

SQL Server Transact SQL Datatype Support

Overview

Extension: babelfishpg_common : SQL Server Transact SQL Datatype Support

Information

  • ID: 9100
  • Name: babelfishpg_common
  • Alias: babelfishpg_common
  • Category: SIM
  • Website: https://babelfishpg.org/
  • License: Apache-2.0 License
  • Language: Unknown
  • Tags: mssql
  • Comment:

Metadata

  • Version: 3.3.3
  • PG Vers: 15
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: WILTON
  • RPM Name: babelfishpg-common*
  • RPM Ver : 3.3.3
  • RPM Deps: Nil
  • DEB Repo: WILTON
  • DEB Name: babelfishpg-common
  • DEB Ver : 3.3.3
  • DEB Deps: Nil

Details

10 - babelfishpg_tsql

SQL Server Transact SQL compatibility

Overview

Extension: babelfishpg_tsql : SQL Server Transact SQL compatibility

Information

  • ID: 9110
  • Name: babelfishpg_tsql
  • Alias: babelfishpg_tsql
  • Category: SIM
  • Website: https://babelfishpg.org/
  • License: Apache-2.0 License
  • Language: Unknown
  • Tags: mssql
  • Comment:

Metadata

  • Version: 3.3.1
  • PG Vers: 15
  • Need Load: Explicit Loading Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: babelfishpg_common, uuid-ossp

Packages

  • RPM Repo: WILTON
  • RPM Name: babelfishpg-tsql*
  • RPM Ver : 3.3.1
  • RPM Deps: Nil
  • DEB Repo: WILTON
  • DEB Name: babelfishpg-tsql
  • DEB Ver : 3.3.1
  • DEB Deps: Nil

Details

11 - babelfishpg_tds

SQL Server TDS protocol extension

Overview

Extension: babelfishpg_tds : SQL Server TDS protocol extension

Information

  • ID: 9120
  • Name: babelfishpg_tds
  • Alias: babelfishpg_tds
  • Category: SIM
  • Website: https://babelfishpg.org/
  • License: Apache-2.0 License
  • Language: Unknown
  • Tags: mssql
  • Comment:

Metadata

  • Version: 1.0.0
  • PG Vers: 15
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: babelfishpg_tsql

Packages

  • RPM Repo: WILTON
  • RPM Name: babelfishpg-tds*
  • RPM Ver : 1.0.0
  • RPM Deps: Nil
  • DEB Repo: WILTON
  • DEB Name: babelfishpg-tds
  • DEB Ver : 1.0.0
  • DEB Deps: Nil

Details

12 - babelfishpg_money

SQL Server Money Data Type

Overview

Extension: babelfishpg_money : SQL Server Money Data Type

Information

  • ID: 9130
  • Name: babelfishpg_money
  • Alias: babelfishpg_money
  • Category: SIM
  • Website: https://babelfishpg.org/
  • License: Apache-2.0 License
  • Language: Unknown
  • Tags: mssql
  • Comment:

Metadata

  • Version: 1.1.0
  • PG Vers: 15
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Relocatable
  • Trusted: Trusted, Can be created by user with CREATE Privilege
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: WILTON
  • RPM Name: babelfishpg-money*
  • RPM Ver : 1.1.0
  • RPM Deps: Nil
  • DEB Repo: WILTON
  • DEB Name: babelfishpg-money
  • DEB Ver : 1.1.0
  • DEB Deps: Nil

Details

13 - pgmemcache

memcached interface

Overview

PGDG 1st Party Extension: pgmemcache : memcached interface

Information

Metadata

  • Version: 2.3.0
  • PG Vers: 17,16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PGDG
  • RPM Name: pgmemcache_$v*
  • RPM Ver : 2.3.0
  • RPM Deps: Nil
  • DEB Repo: PGDG
  • DEB Name: postgresql-$v-pgmemcache
  • DEB Ver : 2.3.0
  • DEB Deps: Nil

Details