Postgres Pro
Downloads
Home   >   mailing lists

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

From Thomas Kellerer
Subject Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl
Date
Msg-id ac813873-575d-c35e-e2c4-b3773798c065@gmx.net
Whole thread Raw
In response to Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl  (Holger Jakobs <holger@jakobs.com>)
Responses Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl  (MichaelDBA <MichaelDBA@sqlexec.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

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