COPY TO json

Edit
ID 4716
Title COPY TO json
CI (CFBot) Summary
Stats (from CFBot) Patch version: v30, Patch count: 3, First patch: +49−36, All patches: +620−65
Tags SQL Commands
Created 2023-12-21 15:10:19
Last modified 2026-03-20 12:43:09 (2 days ago)
Latest email 2026-03-20 12:58:45 (2 days ago)
Status
PG19-Final (2026-03-01 – 2026-03-31): Committed
PG19-4 (2026-01-01 – 2026-01-31): Moved to different CF
PG19-3 (2025-11-01 – 2025-11-30): Moved to different CF
PG19-1 (2025-07-01 – 2025-07-31): Moved to different CF
2025-01 (2025-01-01 – 2025-01-31): Moved to different CF
2024-11 (2024-11-01 – 2024-11-30): Moved to different CF
2024-09 (2024-09-01 – 2024-09-30): Moved to different CF
2024-07 (2024-07-01 – 2024-07-31): Moved to different CF
2024-03 (2024-03-01 – 2024-04-08): Moved to different CF
2024-01 (2024-01-01 – 2024-01-31): Moved to different CF
Target version
Authors Joe Conway (jconway)
Reviewers Masahiko Sawada (masahikosawada), Richard Yen (richyen)Become reviewer
Committer Andrew Dunstan (adunstan)
Links
Emails
Emitting JSON to file using COPY TO
First at 2023-11-25 19:21:37 by Davin Shearer <scholarsmate at gmail.com>
Latest at 2026-03-20 12:58:45 by Joe Conway <mail at joeconway.com>
Latest attachment (v30-0001-introduce-CopyFormat-refactor-CopyFormatOptions.patch) at 2026-03-16 20:59:56 from Andrew Dunstan <andrew at dunslane.net>
    Attachment (v30-0001-introduce-CopyFormat-refactor-CopyFormatOptions.patch) at 2026-03-16 20:59:56 from Andrew Dunstan <andrew at dunslane.net> (Patch: Yes)
    Attachment (copy-json-fixes.patch.nocfbot) at 2026-03-09 12:23:09 from Andrew Dunstan <andrew at dunslane.net> (Patch: Yes)
    Attachment (v29-0002-json-format-for-COPY-TO.patch) at 2026-03-09 03:48:26 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v28-0002-json-format-for-COPY-TO.patch) at 2026-03-08 16:16:08 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v27-0001-introduce-CopyFormat-refactor-CopyFormatOptions.patch) at 2026-03-06 12:33:31 from Andrew Dunstan <andrew at dunslane.net> (Patch: Yes)
    Attachment (v26-0003-Add-option-force_array-for-COPY-JSON-FORMAT.patch) at 2026-03-06 09:38:30 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v25-0001-introduce-CopyFormat-refactor-CopyFormatOptions.patch) at 2026-03-05 20:49:55 from Andrew Dunstan <andrew at dunslane.net> (Patch: Yes)
    Attachment (v24-0001-introduce-CopyFormat-refactor-CopyFormatOptions.patch) at 2026-02-09 03:48:09 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v23-0002-json-format-for-COPY-TO.patch) at 2026-02-06 03:26:04 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v22-0001-introduce-CopyFormat-refactor-CopyFormatOptions.patch) at 2026-01-21 12:15:25 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v21-0002-json-format-for-COPY-TO.patch) at 2025-11-29 02:46:35 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v20-0001-introduce-CopyFormat-refactor-CopyFormatOptions.patch) at 2025-11-10 00:53:02 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v19-0002-json-format-for-COPY-TO.patch) at 2025-10-01 06:16:42 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v18-0003-Add-option-force_array-for-COPY-JSON-FORMAT.patch) at 2025-08-10 15:20:12 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v17-0002-Add-option-force_array-for-COPY-JSON-FORMAT.patch) at 2025-07-04 05:27:08 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v16-0002-Add-option-force_array-for-COPY-JSON-FORMAT.patch) at 2025-03-11 08:23:42 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v15-0002-Add-option-force_array-for-COPY-JSON-FORMAT.patch) at 2025-03-02 05:28:07 from Junwang Zhao <zhjwpku at gmail.com> (Patch: Yes)
    Attachment (v14-0003-Add-option-force_array-for-COPY-JSON-FORMAT.patch) at 2025-01-27 08:16:26 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v13-0002-introduce-json-format-for-COPY-TO.patch) at 2024-11-19 06:16:52 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (scratch31.sql) at 2024-09-13 14:42:00 from jian he <jian.universality at gmail.com> (Patch: No)
    Attachment (v12-0002-Add-option-force_array-for-COPY-TO.patch) at 2024-08-22 05:19:00 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v11-0001-introduce-json-format-for-COPY-TO.patch) at 2024-08-19 00:00:00 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v10-0001-introduce-json-format-for-COPY-TO-operation.patch) at 2024-04-01 12:00:11 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v9-0001-Add-another-COPY-fomrat-json.patch) at 2024-02-19 03:43:39 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v8-0004-Add-support-for-implementing-custom-COPY-TO-forma.patch) at 2024-01-27 05:55:23 from Junwang Zhao <zhjwpku at gmail.com> (Patch: Yes)
    Attachment (v8-0002-Add-force_array-for-COPY-TO-json-fomrat.patch) at 2024-01-23 05:31:00 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (test.sql) at 2024-01-16 03:46:59 from jian he <jian.universality at gmail.com> (Patch: No)
    Attachment (copyto_json.007.diff) at 2023-12-07 01:10:21 from Joe Conway <mail at joeconway.com> (Patch: Yes)
    Attachment (copyto_json.006.diff) at 2023-12-06 13:49:13 from Joe Conway <mail at joeconway.com> (Patch: No)
    Attachment (copyto_json.005.diff) at 2023-12-05 18:51:22 from Joe Conway <mail at joeconway.com> (Patch: No)
    Attachment (copyto_json.004.diff) at 2023-12-05 02:54:50 from Joe Conway <mail at joeconway.com> (Patch: Yes)
    Attachment (copyto_json.003.diff) at 2023-12-04 15:45:58 from Joe Conway <mail at joeconway.com> (Patch: Yes)
    Attachment (copyto_json.001.diff) at 2023-12-03 14:53:49 from Joe Conway <mail at joeconway.com> (Patch: Yes)
    Attachment (copyto_json.000.diff) at 2023-12-01 19:28:55 from Joe Conway <mail at joeconway.com> (Patch: Yes)
History
When Who What
2026-03-20 12:43:09 Andrew Dunstan (adunstan) Closed in commitfest PG19-Final with status: Committed
2026-03-20 12:43:09 Andrew Dunstan (adunstan) Changed committer to adunstan
2026-02-24 17:10:09 Richard Yen (richyen) Added richyen as reviewer
2026-02-01 00:00:09 CFbot Moved from CF PG19-4 to CF PG19-Final
2026-01-21 12:32:33 CFbot Patch does not need rebase anymore
2025-12-24 09:11:22 CFbot Patch needs rebase
2025-12-05 13:37:32 Jian He (stayreal) Moved from CF PG19-3 to CF PG19-4
2025-11-29 03:13:34 CFbot Patch does not need rebase anymore
2025-11-15 23:51:22 CFbot Patch needs rebase
2025-11-10 01:15:30 CFbot Patch does not need rebase anymore
2025-11-05 12:43:25 CFbot Patch needs rebase
2025-10-03 07:01:28 CFbot Patch does not need rebase anymore
2025-10-03 03:39:14 Jian He (stayreal) Moved from CF PG19-1 to CF PG19-3
2025-07-10 08:35:23 CFbot Patch needs rebase
2025-07-04 05:43:26 CFbot Patch does not need rebase anymore
2025-06-14 01:15:32 CFbot Patch needs rebase
2025-06-09 17:04:53 Nathan Bossart (bossartn) Removed bossartn from reviewers
2025-04-08 15:23:27 Nathan Bossart (bossartn) Closed in commitfest 2025-01 with status: Moved to next CF
2024-12-10 06:46:20 Michael Paquier (michael-kun) Closed in commitfest 2024-11 with status: Moved to next CF
2024-12-10 06:46:17 Michael Paquier (michael-kun) New status: Needs review
2024-10-08 02:23:15 Michael Paquier (michael-kun) Closed in commitfest 2024-09 with status: Moved to next CF
2024-10-08 02:23:12 Michael Paquier (michael-kun) New status: Waiting on Author
2024-08-01 01:55:31 Corey Huinker (coreyh) Closed in commitfest 2024-07 with status: Moved to next CF
2024-04-09 06:23:54 Andrey Borodin (x4m) Closed in commitfest 2024-03 with status: Moved to next CF
2024-04-09 06:23:48 Andrey Borodin (x4m) Changed targetversion to None
2024-02-01 18:08:13 vigneshwaran C (vignesh.postgres) Closed in commitfest 2024-01 with status: Moved to next CF
2024-01-16 08:23:54 Masahiko Sawada (masahikosawada) Added masahikosawada as reviewer
2024-01-05 21:26:44 Nathan Bossart (bossartn) Added bossartn as reviewer
2023-12-21 15:11:17 Joe Conway (jconway) Changed authors to Joe Conway (jconway)
2023-12-21 15:11:17 Joe Conway (jconway) Changed committer to jconway
2023-12-21 15:11:17 Joe Conway (jconway) Changed targetversion to 17
2023-12-21 15:10:19 Joe Conway (jconway) Attached mail thread CALvfUkBxTYy5uWPFVwpk_7ii2zgT07t3d-yR_cy4sfrrLU=kcg@mail.gmail.com
2023-12-21 15:10:19 Joe Conway (jconway) Created patch record
Edit