public inbox for [email protected]
help / color / mirror / Atom feedFrom: HexaCluster via PostgreSQL Announce <[email protected]>
To: PostgreSQL Announce <[email protected]>
Subject: pg_dbms_metadata v1.0.0 released
Date: Fri, 05 Jan 2024 20:07:25 +0000
Message-ID: <[email protected]> (raw)
### 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.
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: pg_dbms_metadata v1.0.0 released
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox