Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1peGcY-00026Q-QE for pgsql-admin@arkaria.postgresql.org; Mon, 20 Mar 2023 14:36:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1peGcX-0001mm-J2 for pgsql-admin@arkaria.postgresql.org; Mon, 20 Mar 2023 14:36:21 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1peGcX-0001jo-8I for pgsql-admin@lists.postgresql.org; Mon, 20 Mar 2023 14:36:21 +0000 Received: from mout.gmx.net ([212.227.17.21]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1peGcU-0002fn-M1 for pgsql-admin@lists.postgresql.org; Mon, 20 Mar 2023 14:36:20 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=s31663417; t=1679322976; i=shammat@gmx.net; bh=8dcTlY77bu0uXz6YjjDzC3qIl8Fp7WhYzi1YzWwT1Nc=; h=X-UI-Sender-Class:Subject:To:References:From:Date:In-Reply-To; b=pNkF/9k55/OLVK2DjtWOHZOHPN2kVJVDkpN4ov3Fpq5LcbucvRMY6ONRWdGGXB89u 5v1mEjSN5OoNWvtxwAgiYnRwR56MwKRxq9AupFQCurQ5tcpW/KhmErYuIX+fSJjsiD LwnnBBMWeYjephJ3PUwDZ9BUEEvlRsS7WdAyITHuua67hQBU4fpi+OGghs8yxHUf56 dlpls0byI466DcH0iYgaAgvbdFf+V2T/1sqUdtO33HZnETJkBb3e2N59JSknUSMU1A 1TppUv8JgSd58c/icHT0uK/pfopHIau7k3/od95xotuONS1n5MmMkVCtouliLf5SQk SJKO6YZGrmpdg== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from [10.1.34.101] ([185.40.248.10]) by mail.gmx.net (mrgmx105 [212.227.17.168]) with ESMTPSA (Nemesis) id 1M8ykg-1pbWnm2Ab8-0068lt for ; Mon, 20 Mar 2023 15:36:16 +0100 Subject: Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl To: pgsql-admin@lists.postgresql.org References: <18e53273-264a-2ccf-e1ed-070fc6d7c381@jakobs.com> From: Thomas Kellerer Message-ID: Date: Mon, 20 Mar 2023 15:36:15 +0100 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 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Language: de-DE Content-Transfer-Encoding: quoted-printable X-Provags-ID: V03:K1:YC498JRIV8U9K5+0Auf2leOeOtDXEZ4rbjpkbttp/pKJVkfy5bH 3JflV5ffFy9VQQyFN81XT1XGbX5rx58mFeWjH6i+kG4kjCdVkkCV+HfbV6tnZWE4MZgRLww ynslQXDkg/mrtblHKgz0fM+5kPK/LypyY0JcfdsJmZRyA6GxrhhqPPC/Qv3S3UTa5cXkM+R aGCyto9JnMMUR2IdY82uQ== X-Spam-Flag: NO 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= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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