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: v17, Patch count: 1, First patch: +766−0, All patches: +766−0
Tags
Created 2025-10-16 13:28:57
Last modified 2026-10-01 12:50:59 (1 hour ago)
Latest email 2026-07-13 13:29:45 (2 months ago)
Status
PG20-3 (2026-11-01 – 2026-11-30): Ready for Committer
PG20-2 (2026-09-01 – 2026-09-30): Moved to different CF
PG20-1 (2026-07-01 – 2026-07-31): Moved to different CF
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), Rui Zhao (zhaorui) 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-07-13 13:29:45 by Rui Zhao <zhaorui126 at gmail.com>
Latest attachment (v17-0001-Add-pg_get_policy_ddl-to-reconstruct-CREATE.patch) at 2026-07-13 09:29:17 from Akshay Joshi <akshay.joshi at enterprisedb.com>
    Attachment (v17-0001-Add-pg_get_policy_ddl-to-reconstruct-CREATE.patch) at 2026-07-13 09:29:17 from Akshay Joshi <akshay.joshi at enterprisedb.com> (Patch: Yes)
    Attachment (v16-0001-Add-pg_get_policy_ddl-to-reconstruct-CREATE.patch) at 2026-07-09 10:57:41 from Akshay Joshi <akshay.joshi at enterprisedb.com> (Patch: Yes)
    Attachment (v15-0001-Add-pg_get_policy_ddl-to-reconstruct-CREATE.patch) at 2026-07-06 11:28:18 from Akshay Joshi <akshay.joshi at enterprisedb.com> (Patch: Yes)
    Attachment (v14-0001-Add-pg_get_policy_ddl-to-reconstruct-CREATE.patch) at 2026-06-30 11:18:26 from Akshay Joshi <akshay.joshi at enterprisedb.com> (Patch: Yes)
    Attachment (v13-0001-Add-pg_get_policy_ddl-to-reconstruct-CREATE.patch) at 2026-06-29 13:42:06 from Akshay Joshi <akshay.joshi at enterprisedb.com> (Patch: Yes)
    Attachment (v12-0001-Add-pg_get_policy_ddl-to-reconstruct-CREATE.patch) at 2026-06-22 13:19:27 from Akshay Joshi <akshay.joshi at enterprisedb.com> (Patch: Yes)
    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-10-01 12:50:59 Akshay Joshi (akshay.joshi) Moved from CF PG20-2 to CF PG20-3
2026-07-30 06:24:48 Akshay Joshi (akshay.joshi) Moved from CF PG20-1 to CF PG20-2
2026-07-08 15:22:20 Rui Zhao (zhaorui) Added zhaorui as reviewer
2026-07-01 11:41:10 Akshay Joshi (akshay.joshi) Changed tags to
2026-06-29 14:05:30 CFbot Patch does not need rebase anymore
2026-06-29 11:16:25 CFbot Patch needs rebase
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