Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl - Mailing list pgsql-admin

From MichaelDBA
Subject Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl
Date
Msg-id dd5294a2-fc9e-187d-d14d-f5fe285827fc@sqlexec.com
Whole thread Raw
In response to Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl  (Thomas Kellerer <shammat@gmx.net>)
List pgsql-admin
Tree view
hehehe, thats me

Thomas Kellerer wrote on 3/20/2023 10:36 AM:
Holger Jakobs schrieb am 20.03.2023 um 15:30:

It's not difficult to write table-valued functions returning the DDL
of database objects, but it's a lot of work.

Someone already did the heavy lifting ;)

https://github.com/MichaelDBA/pg_get_tabledef


Regards,

Michael Vitale

Michaeldba@sqlexec.com

703-600-9343 


Attachment

pgsql-admin by date:

Previous
From: richard coleman
Date:
Subject: Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl
Next
From: Tom Lane
Date:
Subject: Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl