Add pg_get_table_ddl() to reconstruct CREATE TABLE statements

Edit
ID 6837
Title Add pg_get_table_ddl() to reconstruct CREATE TABLE statements
CI (CFBot) Summary
Stats (from CFBot) Patch version: v26, Patch count: 1, First patch: +7125−43, All patches: +7125−43
Tags
Created 2026-06-03 13:26:22
Last modified 2026-07-30 06:25:59 (2 months ago)
Latest email 2026-09-23 18:13:39 (1 week ago)
Status
PG20-2 (2026-09-01 – 2026-09-30): Needs review
PG20-1 (2026-07-01 – 2026-07-31): Moved to different CF
Target version
Authors Akshay Joshi (akshay.joshi)
Reviewers Zsolt Parragi (zsolt.parragi), Rui Zhao (zhaorui) Become reviewer
Committer
Links
Emails
[PATCH] Add pg_get_table_ddl() to reconstruct CREATE TABLE statements
First at 2026-06-03 12:58:52 by Akshay Joshi <akshay.joshi at enterprisedb.com>
Latest at 2026-09-23 18:13:39 by Marcos Pegoraro <marcos at f10.com.br>
Latest attachment (v26-0001-Add-pg_get_table_ddl-to-reconstruct-CREATE-TABLE.patch) at 2026-09-23 13:00:37 from Akshay Joshi <akshay.joshi at enterprisedb.com>
    Attachment (v26-0001-Add-pg_get_table_ddl-to-reconstruct-CREATE-TABLE.patch) at 2026-09-23 13:00:37 from Akshay Joshi <akshay.joshi at enterprisedb.com> (Patch: No)
    Attachment (0001-Emit-SET-LOGGED-for-an-unlogged-table-s-logged-ident.patch) at 2026-09-08 15:19:18 from Rui Zhao <zhaorui126 at gmail.com> (Patch: No)
    Attachment (v25-0001-Add-pg_get_table_ddl-to-reconstruct-CREATE-TABLE.patch) at 2026-08-31 11:49:33 from Akshay Joshi <akshay.joshi at enterprisedb.com> (Patch: No)
    Attachment (0001-Judge-a-partition-child-s-names-against-the-target-t.patch) at 2026-08-11 11:51:16 from Rui Zhao <zhaorui126 at gmail.com> (Patch: No)
    Attachment (v24-0001-Add-pg_get_table_ddl-to-reconstruct-CREATE-TABLE.patch) at 2026-08-05 08:21:52 from Akshay Joshi <akshay.joshi at enterprisedb.com> (Patch: No)
    Attachment (v23-0001-Add-pg_get_table_ddl-to-reconstruct-CREATE-TABLE.patch) at 2026-07-27 10:34:52 from Akshay Joshi <akshay.joshi at enterprisedb.com> (Patch: No)
    Attachment (v22-0001-Add-pg_get_table_ddl-to-reconstruct-CREATE-TABLE.patch) at 2026-07-16 09:30:28 from Akshay Joshi <akshay.joshi at enterprisedb.com> (Patch: No)
    Attachment (v21-0001-Add-pg_get_table_ddl-to-reconstruct-CREATE-TABLE.patch) at 2026-07-14 09:56:17 from Akshay Joshi <akshay.joshi at enterprisedb.com> (Patch: No)
    Attachment (v20-0001-Add-pg_get_table_ddl-to-reconstruct-CREATE-TABLE.patch) at 2026-07-13 11:49:22 from Akshay Joshi <akshay.joshi at enterprisedb.com> (Patch: No)
    Attachment (v19-0001-Add-pg_get_table_ddl-to-reconstruct-CREATE-TABLE.patch) at 2026-07-09 08:53:54 from Akshay Joshi <akshay.joshi at enterprisedb.com> (Patch: No)
    Attachment (v18-0001-Add-pg_get_table_ddl-to-reconstruct-CREATE-TABLE.patch) at 2026-07-08 11:56:30 from Akshay Joshi <akshay.joshi at enterprisedb.com> (Patch: No)
    Attachment (v17-0001-Add-pg_get_table_ddl-to-reconstruct-CREATE-TABLE.patch) at 2026-07-06 10:57:56 from Akshay Joshi <akshay.joshi at enterprisedb.com> (Patch: No)
    Attachment (v16-0001-Add-pg_get_table_ddl-to-reconstruct-CREATE-TABLE.patch) at 2026-07-03 08:47:25 from Akshay Joshi <akshay.joshi at enterprisedb.com> (Patch: No)
    Attachment (v15-0001-Add-pg_get_table_ddl-to-reconstruct-CREATE-TABLE.patch) at 2026-07-02 10:39:50 from Akshay Joshi <akshay.joshi at enterprisedb.com> (Patch: No)
    Attachment (v14-0001-Add-pg_get_table_ddl-to-reconstruct-CREATE-TABLE.patch) at 2026-07-01 14:12:31 from Akshay Joshi <akshay.joshi at enterprisedb.com> (Patch: No)
    Attachment (v13-0001-Add-pg_get_table_ddl-to-reconstruct-CREATE-TABLE.patch) at 2026-06-29 13:38:11 from Akshay Joshi <akshay.joshi at enterprisedb.com> (Patch: No)
    Attachment (v12-0001-Add-pg_get_table_ddl-to-reconstruct-CREATE-TABLE.patch) at 2026-06-29 10:40:47 from Akshay Joshi <akshay.joshi at enterprisedb.com> (Patch: No)
    Attachment (v11-0001-Add-pg_get_table_ddl-to-reconstruct-CREATE-TABLE.patch) at 2026-06-24 09:16:03 from Akshay Joshi <akshay.joshi at enterprisedb.com> (Patch: No)
    Attachment (v10-0001-Add-pg_get_table_ddl-to-reconstruct-CREATE-TABLE.patch) at 2026-06-23 13:34:25 from Akshay Joshi <akshay.joshi at enterprisedb.com> (Patch: No)
    Attachment (v9-0001-Add-pg_get_table_ddl-to-reconstruct-CREATE-TABLE.patch) at 2026-06-22 12:40:53 from Akshay Joshi <akshay.joshi at enterprisedb.com> (Patch: Yes)
    Attachment (v8-0001-Add-pg_get_table_ddl-to-reconstruct-CREATE-TABLE.patch) at 2026-06-22 06:26:58 from Akshay Joshi <akshay.joshi at enterprisedb.com> (Patch: Yes)
    Attachment (v7-0001-Add-pg_get_table_ddl-to-reconstruct-CREATE-TABLE.patch) at 2026-06-19 12:19:44 from Akshay Joshi <akshay.joshi at enterprisedb.com> (Patch: Yes)
    Attachment (v6-0001-Add-pg_get_table_ddl-to-reconstruct-CREATE-TABLE.patch) at 2026-06-15 08:55:06 from Akshay Joshi <akshay.joshi at enterprisedb.com> (Patch: Yes)
    Attachment (v5-0001-Add-pg_get_table_ddl-to-reconstruct-CREATE-TABLE.patch) at 2026-06-11 07:48:07 from Akshay Joshi <akshay.joshi at enterprisedb.com> (Patch: Yes)
    Attachment (v4-0001-Add-pg_get_table_ddl-to-reconstruct-CREATE-TABLE.patch) at 2026-06-10 11:24:22 from Akshay Joshi <akshay.joshi at enterprisedb.com> (Patch: Yes)
    Attachment (v3-0001-Add-pg_get_table_ddl-to-reconstruct-CREATE-TABLE.patch) at 2026-06-09 08:58:15 from Akshay Joshi <akshay.joshi at enterprisedb.com> (Patch: Yes)
    Attachment (v2-0001-Add-pg_get_table_ddl-to-reconstruct-CREATE-TABLE.patch) at 2026-06-08 11:30:32 from Akshay Joshi <akshay.joshi at enterprisedb.com> (Patch: Yes)
    Attachment (v1-0001-Add-pg_get_table_ddl-to-reconstruct-CREATE-TABLE.patch) at 2026-06-03 12:58:52 from Akshay Joshi <akshay.joshi at enterprisedb.com> (Patch: Yes)
History
When Who What
2026-09-23 13:34:39 CFbot Patch does not need rebase anymore
2026-09-08 15:40:30 CFbot Patch needs rebase
2026-08-31 12:02:37 CFbot Patch does not need rebase anymore
2026-08-11 12:03:35 CFbot Patch needs rebase
2026-07-30 06:25:59 Akshay Joshi (akshay.joshi) Moved from CF PG20-1 to CF PG20-2
2026-06-30 08:08:38 Rui Zhao (zhaorui) Added zhaorui as reviewer
2026-06-29 11:11:34 CFbot Patch does not need rebase anymore
2026-06-28 22:28:26 CFbot Patch needs rebase
2026-06-19 19:43:46 Zsolt Parragi (zsolt.parragi) Added zsolt.parragi as reviewer
2026-06-03 13:26:22 Akshay Joshi (akshay.joshi) Attached mail thread CANxoLDfjQnhM=E6JSyYo9s9OdjqoN8s_3wE5yL=kaDu_X8j-dA@mail.gmail.com
2026-06-03 13:26:22 Akshay Joshi (akshay.joshi) Created patch record
Edit