pg_dbms_metadata v1.0.0 - Oracle's DBMS_METADATA Compatibility for PostgreSQL DDL Extraction
Latest
HexaCluster is pleased to announce the release of pg_dbms_metadata v1.0.0, a PostgreSQL extension that brings Oracle DBMS_METADATA package compatibility to the PostgreSQL environment. This release marks a significant milestone, providing users with a versatile solution for programmatically extracting Data Definition Language (DDL) for database objects.
Key Features:
-
Oracle DBMS_METADATA Package Compatibility: pg_dbms_metadata offers compatibility with Oracle's DBMS_METADATA package API, facilitating seamless migration and interoperability for users familiar with Oracle's DDL extraction methods.
-
Flexible DDL Retrieval: The extension allows users to extract DDL for various database objects through either plain SQL queries or PL/pgSQL code. This flexibility enables DDL extraction using any client capable of executing plain SQL queries.
-
Dual Purpose Extension: pg_dbms_metadata not only aligns with Oracle's DBMS_METADATA package but also establishes a systematic approach for programmatically retrieving DDL. This extends beyond standard methods like pg_dump, providing users with enhanced options for extracting DDL.
Supported Functions:
- GET_DDL(): Extracts DDL for a specified database object.
- GET_DEPENDENT_DDL(): Extracts DDL for all dependent objects of a specified type related to a base object.
- GET_GRANTED_DDL(): Extracts SQL statements to recreate granted privileges and roles for a specified grantee.
- SET_TRANSFORM_PARAM(): Customizes DDL through session-level transform parameters.
