Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pgsql-admin@xxxxxxxxxxxxxxxxxxxx
Subject: Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl
From: Thomas Kellerer <shammat@xxxxxxx>
Date: Mon, 20 Mar 2023 15:36:15 +0100
In-reply-to: <e26607cb-0591-e5d1-cf5b-4cefb627f91e@jakobs.com>
References: <CAGA3vBt=an4RqygEvUeeLPB_s0W92hC2DtjFmxV2eKu93NWOKA@mail.gmail.com> <18e53273-264a-2ccf-e1ed-070fc6d7c381@jakobs.com> <CAGA3vBvvCf3=BLt0ehGbevjRp8O9d-X6Hi6NWKRiDcEpmvwg8w@mail.gmail.com> <e26607cb-0591-e5d1-cf5b-4cefb627f91e@jakobs.com>
Ui-outboundreport: notjunk:1;M01:P0:0E+eiQsK9BQ=;KrOeYwquBYYvV8oGkC5B97hXv22 sGnhotwwIdJzf7z9MzE2gzooo4KOgTGzPdTR5RCJMQh8UQKvJgQcCZn/DL0H5cFGYNMrN7xNY 808boSCLawkjgXau86b+jHEPHQEF424XeHNoHlzrxlao0gEDz7Cn3Kb4xQiJqX+sw/QDgiKJ4 pDbOMyE7w9U1EqfdHbzp7dl/VSjjgnBVlX5djz9rK2AJxdQJS3yRQntRLFV6TvTBweW+aZn01 ArqUEhLnSSgN5p8VwBVb5jfl8XKS6a+yJLidQopLSUPQhs5NnnGTRyTqKkRODFxUZmv9GHTlA blDDFpX7+2PtsqtE5tdcl5sO4RhZXlaQPp0HYnxtrUC8QLhJOCqOkKcYSpxdjG5d5ITSI3N+4 hiPbaYc+0lSNLWbsNgRwDyShMh/d7LQZ7CQY1djAjN3tajDqSqRGQWwC54CL5CgDjIudDjJYq qf0HlqPNsaLVWgUeJB10IgI6LBhnIVjO4AzL1oi20I6YxRMGiIi5a2+XboT5LCxN43BP1QXsH E+8nANPS2YSGidneQCrkLJD9VhhROX84rEerm514a+ADWZ5bKl0usJX+rtUJQ1IHa8KwsLcRV InbGElVWZrkXOiFUv41fHa7Lu6LINMyxjWjnPgBXC6K+0yhKKaHf6he2D0jXyeQRV50oQeTQE baP3ygX3VZhM+bH6KI5CO2KmDmNtmS7BHQH9cLCJk/dcTDOZ+M972kC6uKl5Wck6iZP9ZBOxO GIKSEroZ9gqlcDhMijd2w7y4BQ2Dtgoa3Ba41Ge81/h9kYf47J5eVmB+rqiIs9cTI/ewgveZw vMBf8mBG7QKBhcslnH2zvSar9bK35Q+x0fdk5aotE40g7IpTGetBnUqFFgUKpwBCKEWtCxgf/ 0LXH8uM7KCEp/bDDZA0kn/sYTBWQlUCYT8JNHLWXJNcAP7Vi+DzxZgFUjQ/OaZMKQgb5+7I29 d4KpcBedN1c0grxDZPL120I/eRM=
User-agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.23) Gecko/20090812 Thunderbird/2.0.0.23 Mnenhy/0.7.6.666

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

Follow-Ups:
- Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl
  - From: MichaelDBA

References:
- PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl
  - From: richard coleman
- Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl
  - From: Holger Jakobs
- Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl
  - From: richard coleman
- Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl
  - From: Holger Jakobs

Prev by Date: Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl
Next by Date: Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl
Previous by thread: Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl
Next by thread: Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Home] [Postgresql General] [Postgresql Performance] [Postgresql PHP] [Postgresql Jobs] [PHP Users] [PHP Databases] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Yosemite Forum]