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 1pe9zM-00080O-8X for pgsql-admin@arkaria.postgresql.org; Mon, 20 Mar 2023 07:31:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pe9zK-0002Po-MQ for pgsql-admin@arkaria.postgresql.org; Mon, 20 Mar 2023 07:31:26 +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 1pe9zK-0002Pf-BR for pgsql-admin@lists.postgresql.org; Mon, 20 Mar 2023 07:31:26 +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 1pe9zH-00074I-Ow for pgsql-admin@lists.postgresql.org; Mon, 20 Mar 2023 07:31:25 +0000 Received: from localhost (localhost [127.0.0.1]) by rs.plausibolo.de (Postfix) with ESMTP id 433B53803CD; Mon, 20 Mar 2023 08:31:21 +0100 (CET) Received: from rs.plausibolo.de ([IPv6:::1]) by localhost (h2367442.stratoserver.net [IPv6:::1]) (amavisd-new, port 10024) with ESMTP id Ybx_jkvCnhYf; Mon, 20 Mar 2023 08:31:21 +0100 (CET) Received: from [192.168.222.197] (unknown [145.253.118.26]) by rs.plausibolo.de (Postfix) with ESMTPSA id 0369438039E; Mon, 20 Mar 2023 08:31:20 +0100 (CET) Message-ID: <18e53273-264a-2ccf-e1ed-070fc6d7c381@jakobs.com> Date: Mon, 20 Mar 2023 08:31:19 +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: 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="------------U5F2pigleTSnJeAhEh0Ef5P0" 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) --------------U5F2pigleTSnJeAhEh0Ef5P0 Content-Type: multipart/mixed; boundary="------------iTGZBHrWKa0HItpbSMiUmiis"; protected-headers="v1" From: Holger Jakobs To: pgsql-admin@lists.postgresql.org Message-ID: <18e53273-264a-2ccf-e1ed-070fc6d7c381@jakobs.com> Subject: Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl References: In-Reply-To: --------------iTGZBHrWKa0HItpbSMiUmiis Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 QW0gMTkuMDMuMjMgdW0gMjI6MzYgc2NocmllYiByaWNoYXJkIGNvbGVtYW46DQo+IEhlbGxv IGFsbCwNCj4gSSBhbSB0cnlpbmcgdG8gZmluZCBhIHNpbXBsZSB3YXkgdG8gZ2V0IGFjY2Vz cyB0aGUgRERMIGluZm9ybWF0aW9uIGZvciANCj4gUG9zdGdyZVNRTCB0YWJsZXMsIGNvbnN0 cmFpbnRzLCBhbmQgaW5kaWNlcyB2aWEgU1FMLg0KPg0KPiBJbiBPcmFjbGUgdGhlcmUgYXJl IHRoZcKgZGJtc19tZXRhZGF0YS5nZXRfZGRsKCkgDQo+IGFuZMKgZGJtc19tZXRhZGF0YS5n ZXRfZGVwZW5kZW50X2RkbCgpIGZ1bmN0aW9ucyB0aGF0IHlvdSBjYW4gY2FsbCBvbiANCj4g ZHVhbCB0byBnZXQgdGhpcyBpbmZvcm1hdGlvbi4NCj4NCj4gRVg6DQo+IC0tIHRhYmxlIERE TDoNCj4gc2VsZWN0IGRibXNfbWV0YWRhdGEuZ2V0X2RkbCgnVEFCTEUnLCAnTVlfVEFCTEUn LCdNWV9TQ0hFTUEnKSBhcyANCj4gInRhYmxlX2RkbCIgZnJvbSBkdWFsOw0KPg0KPiAtLSBp bmRpY2VzIERETA0KPiBzZWxlY3QgZGJtc19tZXRhZGF0YS5nZXRfZGVwZW5kZW50X2RkbCgn SU5ERVgnLCdNWV9UQUJMRScsJ01ZX1NDSEVNQScpIA0KPiBhcyAidGFibGVfaW5kaWNpZXMi IGZyb20gZHVhbDsNCj4NCj4gLS0gY29uc3RyYWludHMgRERMDQo+IHNlbGVjdCANCj4gZGJt c19tZXRhZGF0YS5nZXRfZGVwZW5kZW50X2RkbCgnQ09OU1RSQUlOVCcsJ01ZX1RBQkxFJywn TVlfU0NIRU1BJykgDQo+IGFzICJjb25zdHJhaW50c19kZGwiIGZyb20gZHVhbDsNCj4NCj4g SXMgdGhlcmUgYW4gZXF1aXZhbGVudCBmdW5jdGlvbiB0byBkbyB0aGUgc2FtZSBpbiBQb3N0 Z3JlU1FMPw0KPg0KPiBJIGtub3cgdGhlcmUgYXJlIHdheXMgdmlhIHBnX2R1bXAgYW5kIHBz cWwsIGJ1dCB3aGF0IEkgbmVlZCBpcyBhIHdheSANCj4gdG8gZG8gc28gdmlhIFNRTC4NCj4N Cj4gVGhhbmtzLA0KPiByaWsuDQoNCkV2ZXJ5IHNhbmUgUkRCTVMgaGFzIHRoZSBJTkZPUk1B VElPTl9TQ0hFTUEgYWNjb3JkaW5nIHRvIHRoZSBJU08gU1FMIA0KU3RhbmRhcmQsIHNvIHRo YXQgeW91IGNhbiBmaW5kIG91dCBhbGwgb2YgdGhlc2UuDQoNCkJ0dywgdGhlIG9wcG9zaXRl IGlzbid0IHRydWUuIFRoZSBleGlzdGVuY2Ugb2YgdGhlIElORk9STUFUSU9OX1NDSEVNQSAN CmFsb25lIGRvZXNuJ3QgbWFrZSBhbiBSREJNUyBzYW5lLg0KDQpPZiBjb3Vyc2UgdGhlcmUg YXJlIHByb3ByaWV0YXJ5IHZpZXdzIGluIHBnX2NhdGFsb2cgYXMgd2VsbC4gQW5kIHBnX2R1 bXAgDQotcyBjYW4gZHVtcCB0aGUgd2hvbGUgc2NoZW1hIGluIGNsZWFyIHRleHQuDQoNClJl Z2FyZHMsDQoNCkhvbGdlcg0KDQoNCi0tIA0KSG9sZ2VyIEpha29icywgQmVyZ2lzY2ggR2xh ZGJhY2gsIFRlbC4gKzQ5LTE3OC05NzU5MDEyDQoNCg== --------------iTGZBHrWKa0HItpbSMiUmiis-- --------------U5F2pigleTSnJeAhEh0Ef5P0 Content-Type: application/pgp-signature; name="OpenPGP_signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="OpenPGP_signature" -----BEGIN PGP SIGNATURE----- wmMEABEIACMWIQScuJCxWJK1p5BOebGKV5yTsxlhugUCZBgLxwUDAAAAAAAKCRCKV5yTsxlhumEO AJ9IRppXXNqZjTlMTFXhjHlDqPbIuQCeMXqfxraBwDnIlRK25AjmqiKEFXg= =qtNd -----END PGP SIGNATURE----- --------------U5F2pigleTSnJeAhEh0Ef5P0--