Add pg_get_policy_ddl() function to reconstruct CREATE POLICY statement

Edit
ID 6135
Title Add pg_get_policy_ddl() function to reconstruct CREATE POLICY statement
CI (CFBot) Summary
Stats (from CFBot) Patch version: v11, Patch count: 1, First patch: +607−0, All patches: +607−0
Tags My First Patch
Created 2025-10-16 13:28:57
Last modified 2026-05-29 08:00:04 (2 weeks ago)
Latest email 2026-06-08 12:41:12 (4 days ago)
Status
PG20-1 (2026-07-01 – 2026-07-31): Ready for Committer
PG19-3 (2025-11-01 – 2025-11-30): Moved to different CF
Target version
Authors Akshay Joshi (akshay.joshi)
Reviewers Ilmar Yunusov (tanswis42.gmail.com), solai v (solaiv) Become reviewer
Committer
Links
Emails
[PATCH] Add pg_get_policy_ddl() function to reconstruct CREATE POLICY statement
First at 2025-10-15 13:37:12 by Akshay Joshi <akshay.joshi at enterprisedb.com>
Latest at 2026-06-08 12:41:12 by solai v <solai.cdac at gmail.com>
Latest attachment (v11-0001-Add-pg_get_policy_ddl-function-to-reconstruct-CREATE.patch) at 2026-05-29 06:50:54 from Akshay Joshi <akshay.joshi at enterprisedb.com>
    Attachment (v11-0001-Add-pg_get_policy_ddl-function-to-reconstruct-CREATE.patch) at 2026-05-29 06:50:54 from Akshay Joshi <akshay.joshi at enterprisedb.com> (Patch: Yes)
    Attachment (v10-0001-Add-pg_get_policy_ddl-function-to-reconstruct-CREATE.patch) at 2026-05-25 07:17:41 from Akshay Joshi <akshay.joshi at enterprisedb.com> (Patch: Yes)
    Attachment (v9-0001-Add-pg_get_policy_ddl-function-to-reconstruct-CREATE.patch) at 2026-05-22 13:32:46 from Akshay Joshi <akshay.joshi at enterprisedb.com> (Patch: Yes)
    Attachment (v8-0001-Add-pg_get_policy_ddl-function-to-reconstruct-CREATE.patch) at 2025-11-20 09:27:05 from Akshay Joshi <akshay.joshi at enterprisedb.com> (Patch: Yes)
    Attachment (v7-0001-Add-pg_get_policy_ddl-function-to-reconstruct-CREATE.patch) at 2025-11-07 12:20:52 from Akshay Joshi <akshay.joshi at enterprisedb.com> (Patch: Yes)
    Attachment (v6-0001-Add-pg_get_policy_ddl-function-to-reconstruct-CREATE.patch) at 2025-11-03 11:47:40 from Akshay Joshi <akshay.joshi at enterprisedb.com> (Patch: Yes)
    Attachment (v5-0001-Add-pg_get_policy_ddl-function-to-reconstruct-CREATE.patch) at 2025-10-28 09:38:03 from Akshay Joshi <akshay.joshi at enterprisedb.com> (Patch: Yes)
    Attachment (for-optional-pretty.diff) at 2025-10-27 16:45:10 from Mark Wong <markwkm at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Add-pg_get_policy_ddl-function-to-reconstruct-CREATE.patch) at 2025-10-22 13:21:50 from Akshay Joshi <akshay.joshi at enterprisedb.com> (Patch: Yes)
    Attachment (v3-0001-Add-pg_get_policy_ddl-function-to-reconstruct-CREATE.patch) at 2025-10-16 12:50:50 from Akshay Joshi <akshay.joshi at enterprisedb.com> (Patch: Yes)
    Attachment (v2-0001-Add-pg_get_policy_ddl-function-to-reconstruct-CREATE.patch) at 2025-10-16 08:34:21 from Akshay Joshi <akshay.joshi at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Add-pg_get_policy_ddl-function-to-reconstruct-CREATE.patch) at 2025-10-15 13:37:12 from Akshay Joshi <akshay.joshi at enterprisedb.com> (Patch: Yes)
History
When Who What
2026-06-08 04:59:15 solai v (solaiv) Added solaiv as reviewer
2026-05-30 12:14:33 Ilmar Yunusov (tanswis42.gmail.com) Posted review with messageid <178014327373.1017.715417267880560508.pgcf@coridan.postgresql.org>
2026-05-29 08:00:04 Akshay Joshi (akshay.joshi) New status: Ready for Committer
2026-05-28 13:41:58 Ilmar Yunusov (tanswis42.gmail.com) Posted review with messageid <177997571870.313758.10720313850275742354.pgcf@coridan.postgresql.org>
2026-05-28 13:41:58 Ilmar Yunusov (tanswis42.gmail.com) New status: Waiting on Author
2026-05-28 13:36:41 Ilmar Yunusov (tanswis42.gmail.com) Added tanswis42.gmail.com as reviewer
2026-05-22 14:01:34 CFbot Patch does not need rebase anymore
2026-05-22 13:15:28 CFbot Patch needs rebase
2026-05-22 13:13:54 Akshay Joshi (akshay.joshi) Moved from CF PG19-3 to CF PG20-1
2025-10-28 10:03:27 CFbot Patch does not need rebase anymore
2025-10-27 17:04:22 CFbot Patch needs rebase
2025-10-16 13:28:57 Akshay Joshi (akshay.joshi) Attached mail thread CANxoLDdJsRJqnjMXV3yjsk07Z5iRWxG-c2hZJC7bAKqf8ZXj_A@mail.gmail.com
2025-10-16 13:28:57 Akshay Joshi (akshay.joshi) Created patch record
Edit