pg_dbms_metadata v1.0.0 released

From: HexaCluster via PostgreSQL Announce <announce-noreply(at)postgresql(dot)org>
To: PostgreSQL Announce <pgsql-announce(at)lists(dot)postgresql(dot)org>
Subject: pg_dbms_metadata v1.0.0 released
Date: 2024-01-05 20:07:25
Message-ID: 170448524523.666.3303777980596564745@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-announce

### PostgreSQL pg_dbms_metadata extension

This is a PostgreSQL extension to extract DDL of database objects in a way compatible to Oracle DBMS_METADATA package. This extension establishes a systematic approach to programmatically retrieve DDL for objects. You now have the flexibility to generate DDL for an object either from a plain SQL query or from PL/pgSQL code.

The following functions and stored procedures are implemented:

* ```GET_DDL()``` This function extracts DDL of specified object.

* ```GET_DEPENDENT_DDL()``` This function extracts DDL of all dependent objects of specified type for a specified base object.

* ```GET_GRANTED_DDL()``` This function extracts the SQL statements to recreate granted privileges and roles for a specified grantee.

* ```SET_TRANSFORM_PARAM()``` This procedure is used to customize DDL through configuring session-level transform params.

This is the initial release of this extension.

### Links & Credits
Any contribution to build a better tool is welcome. You can send your ideas, features requests or patches using the GitHub tools.

Links :

Download [https://github.com/hexacluster/pg_dbms_metadata/releases](https://github.com/hexacluster/pg_dbms_metadata/releases)

Support [https://github.com/hexacluster/pg_dbms_metadata/issues](https://github.com/hexacluster/pg_dbms_metadata/issues)

Documentation [https://github.com/hexacluster/pg_dbms_metadata#readme](https://github.com/hexacluster/pg_dbms_metadata#readme)

### About pg_dbms_metadata
The pg_dbms_metadata extension is an original work at HexaCluster Corp. Akhil Reddy Banappagari, Avinash Vallarapu and Gilles Darold are the authors and the official maintainers.

Browse pgsql-announce by date

  From Date Subject
Next Message PostgreSQL Europe via PostgreSQL Announce 2024-01-08 14:33:22 FOSDEM PGDay 2024 - Schedule Posted and Registration Open!
Previous Message UCLL via PostgreSQL Announce 2024-01-02 07:56:59 PGConf.BE 2024: Mark your calendar, May 7th