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 1peGWZ-0001oZ-Qw for pgsql-admin@arkaria.postgresql.org; Mon, 20 Mar 2023 14:30:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1peGWW-0008Pl-UC for pgsql-admin@arkaria.postgresql.org; Mon, 20 Mar 2023 14:30:08 +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 1peGWW-0008Pc-JI for pgsql-admin@lists.postgresql.org; Mon, 20 Mar 2023 14:30:08 +0000 Received: from jakobs.com ([85.214.83.89] helo=rs.plausibolo.de) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1peGWT-0002bU-Va for pgsql-admin@lists.postgresql.org; Mon, 20 Mar 2023 14:30:07 +0000 Received: from localhost (localhost [127.0.0.1]) by rs.plausibolo.de (Postfix) with ESMTP id BE7AD380334; Mon, 20 Mar 2023 15:30:03 +0100 (CET) Received: from rs.plausibolo.de ([127.0.0.1]) by localhost (h2367442.stratoserver.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id LMkp-jLAawii; Mon, 20 Mar 2023 15:30:03 +0100 (CET) Received: from [192.168.222.183] (unknown [145.253.118.26]) by rs.plausibolo.de (Postfix) with ESMTPSA id 78F673802F5; Mon, 20 Mar 2023 15:30:03 +0100 (CET) Message-ID: Date: Mon, 20 Mar 2023 15:30:02 +0100 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.8.0 Content-Language: de-DE, en-US To: pgsql-admin@lists.postgresql.org References: <18e53273-264a-2ccf-e1ed-070fc6d7c381@jakobs.com> From: Holger Jakobs Subject: Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------UeEH1j6Ko0Z9C0E3tp1tGrKw" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --------------UeEH1j6Ko0Z9C0E3tp1tGrKw Content-Type: multipart/mixed; boundary="------------8z3vrnB008NK1XmwCnZzea7Y"; protected-headers="v1" From: Holger Jakobs To: pgsql-admin@lists.postgresql.org Message-ID: Subject: Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl References: <18e53273-264a-2ccf-e1ed-070fc6d7c381@jakobs.com> In-Reply-To: --------------8z3vrnB008NK1XmwCnZzea7Y Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 QW0gMjAuMDMuMjMgdW0gMTU6MDIgc2NocmllYiByaWNoYXJkIGNvbGVtYW46DQo+IEhvbGdl ciwNCj4NCj4gVGhhbmtzLCBidXQgSSB3YXMgbG9va2luZyBmb3IgYSBTUUwgY2FsbGFibGUg ZnVuY3Rpb24ocyksIGFuYWxvZ291cyB0byANCj4gdGhlIE9yYWNsZcKgIGRibXNfbWV0YWRh dGEuZ2V0X2RkbCgpICYgDQo+IGRibXNfbWV0YWRhdGEuZ2V0X2RlcGVuZGVudF9kZGwoKSBm dW5jdGlvbnMgdGhhdCByZXR1cm4gRERMIGluIHBsYWluIA0KPiB0ZXh0IGZyb20gYW4gU1FM IHF1ZXJ5Lg0KPg0KPiBJdCBhcHBlYXJzIHRoYXQgUG9zdGdyZVNRTCBkb2Vzbid0IGhhdmUg dGhhdCBhYmlsaXR5LCBhdCBsZWFzdCBub3QgYXMgDQo+IGEgYnVpbHQtaW4gZnVuY3Rpb24g YW5kIHdpdGggdGhlIHN1Z2dlc3Rpb25zIG9mIG90aGVycyBvbiB0aGlzIGxpc3QgDQo+IEkn bGwgaGF2ZSB0byB3cml0ZSBteSBvd24uDQo+DQo+IFRoYW5rcyBhZ2FpbiwNCj4gcmlrLg0K Pg0KUmlrLA0KDQpCdXQgeW91IHJlYWxpemUgdGhhdCBvbiB0aGUgb3RoZXIgaGFuZCBhIFBv c3RncmVTUUwgdXNlciBzd2l0Y2hpbmcgdG8gDQpPcmFjbGUgY291bGQgc2F5Og0KDQoiSXQg YXBwZWFycyB0aGF0IE9yYWNsZSBsYWNrcyBQb3N0Z3JlU1FMJ3MgcHJvcHJpZXRhcnkgdmll d3Mgc2hvd2luZyB0aGUgDQpzdHJ1Y3R1cmUgb2YgdGhlIGRhdGFiYXNlLiINCg0KQWN0dWFs bHksIG5vdGhpbmcgYmVzaWRlcyB0aGUgSVNPIHN0YW5kYXJkIElORk9STUFUSU9OIFNDSEVN QSBpcyBpbiBhbnkgDQp3YXkgc3RhbmRhcmRpc2VkLiBUaGUgU1FMIHN0YW5kYXJkIGlzIG5v dCBjb21wcmVoZW5zaXZlIGhlcmUgYW5kIGxlYXZlcyANCmEgbG90IHRvIHRoZSBpbXBsZW1l bnRvci4NCg0KSXQncyBub3QgZGlmZmljdWx0IHRvIHdyaXRlIHRhYmxlLXZhbHVlZCBmdW5j dGlvbnMgcmV0dXJuaW5nIHRoZSBEREwgb2YgDQpkYXRhYmFzZSBvYmplY3RzLCBidXQgaXQn cyBhIGxvdCBvZiB3b3JrLg0KDQpSZWdhcmRzLA0KDQpIb2xnZXINCg0KDQotLSANCkhvbGdl ciBKYWtvYnMsIEJlcmdpc2NoIEdsYWRiYWNoLCBUZWwuICs0OS0xNzgtOTc1OTAxMg0KDQo= --------------8z3vrnB008NK1XmwCnZzea7Y-- --------------UeEH1j6Ko0Z9C0E3tp1tGrKw Content-Type: application/pgp-signature; name="OpenPGP_signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="OpenPGP_signature" -----BEGIN PGP SIGNATURE----- wmMEABEIACMWIQScuJCxWJK1p5BOebGKV5yTsxlhugUCZBht6gUDAAAAAAAKCRCKV5yTsxlhugg/ AJ9eCoWXJAtin55Veu4CVwQwNbHsgACeJnLe/3haiLfeYsseb4Pw6Ozmo+8= =XVQ7 -----END PGP SIGNATURE----- --------------UeEH1j6Ko0Z9C0E3tp1tGrKw--