Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wSazx-003Hby-0p for pgsql-hackers@arkaria.postgresql.org; Thu, 28 May 2026 13:42:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wSazu-00CJ1b-2c for pgsql-hackers@arkaria.postgresql.org; Thu, 28 May 2026 13:42:07 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wSazu-00CJ1T-1h for pgsql-hackers@lists.postgresql.org; Thu, 28 May 2026 13:42:07 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wSazt-00000001rZs-0Uxq for pgsql-hackers@lists.postgresql.org; Thu, 28 May 2026 13:42:06 +0000 Received: from coridan.postgresql.org ([2001:4800:3e1:1::213]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wSazr-003hkM-18 for pgsql-hackers@lists.postgresql.org; Thu, 28 May 2026 13:42:03 +0000 Received: from localhost ([127.0.0.1] helo=coridan.postgresql.org) by coridan.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wSazq-0046je-3B for pgsql-hackers@lists.postgresql.org; Thu, 28 May 2026 13:42:02 +0000 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Subject: Re: [PATCH] Add pg_get_policy_ddl() function to reconstruct CREATE POLICY statement To: pgsql-hackers@lists.postgresql.org From: Ilmar Y Cc: Akshay Joshi Date: Thu, 28 May 2026 13:41:58 +0000 User-Agent: pgcommitfest X-cfsender: tanswis42.gmail.com In-Reply-To: References: Message-ID: <177997571870.313758.10720313850275742354.pgcf@coridan.postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk VGhlIGZvbGxvd2luZyByZXZpZXcgaGFzIGJlZW4gcG9zdGVkIHRocm91Z2ggdGhlIGNvbW1pdGZl c3QgYXBwbGljYXRpb246Cm1ha2UgaW5zdGFsbGNoZWNrLXdvcmxkOiAgbm90IHRlc3RlZApJbXBs ZW1lbnRzIGZlYXR1cmU6ICAgICAgIHRlc3RlZCwgZmFpbGVkClNwZWMgY29tcGxpYW50OiAgICAg ICAgICAgbm90IHRlc3RlZApEb2N1bWVudGF0aW9uOiAgICAgICAgICAgIG5vdCB0ZXN0ZWQKCkhp LA0KDQpJIGxvb2tlZCBhdCB2MTAsIGZvY3VzZWQgb24gd2hldGhlciB0aGUgZ2VuZXJhdGVkIENS RUFURSBQT0xJQ1kgc3RhdGVtZW50DQpjYW4gYmUgZXhlY3V0ZWQgYWdhaW4uDQoNClRoZSBwYXRj aCBhcHBsaWVzIGNsZWFubHkgb24gY3VycmVudCBtYXN0ZXIgYXQNCjhhODZhYTMxM2E3MTRhZGM1 NmM3NGU0YjA4NzkzZTRlNjEwMmI1Y2EuDQoNCmdpdCBkaWZmIC0tY2hlY2sgcmVwb3J0cyBubyBp c3N1ZXMuDQoNCkkgYnVpbHQgd2l0aDoNCg0KLi9jb25maWd1cmUgLS1wcmVmaXg9IiRQV0QvcGct aW5zdGFsbCIgLS13aXRob3V0LXJlYWRsaW5lIC0td2l0aG91dC16bGliIC0td2l0aG91dC1pY3UN Cm1ha2UgLXMgLWo4DQptYWtlIC1zIGluc3RhbGwNCg0KbWFrZSAtQyBzcmMvdGVzdC9yZWdyZXNz IGNoZWNrIFRFU1RTPXJvd3NlY3VyaXR5DQoNCmVuZGVkIHVwIHJ1bm5pbmcgdGhlIGZ1bGwgcGFy YWxsZWxfc2NoZWR1bGUgaW4gdGhpcyBtYWtlZmlsZTsgYWxsIDI0NSB0ZXN0cw0KcGFzc2VkLCBp bmNsdWRpbmcgcm93c2VjdXJpdHkuDQoNCkkgZm91bmQgb25lIGNvcnJlY3RuZXNzIGlzc3VlIGlu IHRoZSBnZW5lcmF0ZWQgbm9uLXByZXR0eSBEREwuICBUaGUgY29kZQ0KYXNzdW1lcyB0aGF0IHBn X2dldF9leHByX2V4dCguLi4sIGZhbHNlKSBhbHJlYWR5IHJldHVybnMgdGhlIHBhcmVudGhlc2Vz DQpyZXF1aXJlZCBieSBDUkVBVEUgUE9MSUNZIHN5bnRheCwgYnV0IHRoYXQgaXMgbm90IHRydWUg Zm9yIHNpbXBsZSBib29sZWFuDQpjb25zdGFudHMuDQoNCkZvciBleGFtcGxlOg0KDQpDUkVBVEUg VEFCTEUgdChhIGludCk7DQpDUkVBVEUgUE9MSUNZIHBfdHJ1ZSBPTiB0IFVTSU5HICh0cnVlKTsN ClNFTEVDVCBkZGwgRlJPTSBwZ19nZXRfcG9saWN5X2RkbCgndCcsICdwX3RydWUnLCAncHJldHR5 JywgJ2ZhbHNlJykgQVMgZGRsOw0KDQpyZXR1cm5zOg0KDQpDUkVBVEUgUE9MSUNZIHBfdHJ1ZSBP TiBwdWJsaWMudCBVU0lORyB0cnVlOw0KDQpJZiBJIGRyb3AgdGhlIHBvbGljeSBhbmQgZXhlY3V0 ZSB0aGF0IGdlbmVyYXRlZCBzdGF0ZW1lbnQsIGl0IGZhaWxzOg0KDQpFUlJPUjogIHN5bnRheCBl cnJvciBhdCBvciBuZWFyICJ0cnVlIg0KTElORSAxOiBDUkVBVEUgUE9MSUNZIHBfdHJ1ZSBPTiBw dWJsaWMudCBVU0lORyB0cnVlOw0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICBeDQoNClRoZSBzYW1lIGlzc3VlIHJlcHJvZHVjZXMgZm9yIFdJVEggQ0hFQ0s6 DQoNCkNSRUFURSBQT0xJQ1kgcF9jaGVjayBPTiB0IEZPUiBJTlNFUlQgV0lUSCBDSEVDSyAoZmFs c2UpOw0KDQppcyByZWNvbnN0cnVjdGVkIGFzOg0KDQpDUkVBVEUgUE9MSUNZIHBfY2hlY2sgT04g cHVibGljLnQgRk9SIElOU0VSVCBXSVRIIENIRUNLIGZhbHNlOw0KDQphbmQgZXhlY3V0aW5nIGl0 IGZhaWxzIGF0ICJmYWxzZSIuDQoNClNvIEkgdGhpbmsgVVNJTkcgYW5kIFdJVEggQ0hFQ0sgbmVl ZCB0byBiZSBwYXJlbnRoZXNpemVkIGluIG5vbi1wcmV0dHkgbW9kZQ0KdG9vLCBvciB0aGUgdGVz dHMgc2hvdWxkIGluY2x1ZGUgYSByb3VuZC10cmlwIGV4ZWN1dGlvbiBjaGVjayBmb3IgZ2VuZXJh dGVkDQpEREwgd2l0aCBzaW1wbGUgYm9vbGVhbiBleHByZXNzaW9ucy4NCg0KSSB1c2VkIHR3byBz bWFsbCBTUUwgcmVwcm9kdWNlcnMgZm9yIHRoZSBtYW51YWwgY2hlY2tzOyB0aGUgY29tcGxldGUg cmVwcm8gaXMNCmluY2x1ZGVkIGFib3ZlLg0KDQpJIGhhdmUgbm90IHJldmlld2VkIHRoZSBicm9h ZGVyIHBnX2dldF8qX2RkbCBBUEkgZGVzaWduIG9yIGV2ZXJ5IHBvc3NpYmxlDQpwb2xpY3kgZXhw cmVzc2lvbiBmb3JtLg0KDQpSZWdhcmRzLA0KSWxtYXIgWXVudXNvdgoKVGhlIG5ldyBzdGF0dXMg b2YgdGhpcyBwYXRjaCBpczogV2FpdGluZyBvbiBBdXRob3IK