Skip to content

Releases: HexaCluster/pg_dbms_metadata

pg_dbms_metadata v1.0.0 - Oracle's DBMS_METADATA Compatibility for PostgreSQL DDL Extraction

03 Jan 10:54
Compare
Choose a tag to compare

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.

Authors: