Implements a subset of Oracle's DBMS_SQL package API to ease application migration to PostgreSQL.
pgext.cloud · Source code · Documentation · License text · Control file
| Package | dbms_sql |
|---|---|
| Version | 1.0 |
| PostgreSQL versions | 11 · 12 · 13 · 14 · 15 · 16 · 17 · 18 |
| Repository | Unspecified |
| Extension type | Standard |
| Project status | Archived |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | No |
| Relocatable | No |
| Schema | dbms_sql |
| Stars | 8 |
| Latest commit | 2022-06-13 |
| Catalogue updated | 2026-08-30 |
| orafce | Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS |
| pg_dbms_job | Extension to add Oracle DBMS_JOB full compatibility to PostgreSQL |
| ora_migrator | Tools to migrate Oracle databases to PostgreSQL |
| check_orapg | Validate Oracle-to-PostgreSQL or EDB migrations by comparing database objects, privileges, attributes, comments, and row counts. |
| pg_dbms_metadata | Extension to add Oracle DBMS_METADATA compatibility to PostgreSQL |
| pg_utl_smtp | Oracle UTL_SMTP compatibility extension for PostgreSQL |
| pg_dbms_lock | Extension to add Oracle DBMS_LOCK full compatibility to PostgreSQL |
| pg_dbms_errlog | Emulate DBMS_ERRLOG Oracle module to log DML errors in a dedicated table. |
| pg_statement_rollback | Server side rollback at statement level for PostgreSQL like Oracle or DB2 |
| plpgsql_wrap | Oracle WRAP-equivalent PL/pgSQL language handler storing AES-256-GCM encrypted procedure source. |