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 :
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.
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 |