Re: Emitting JSON to file using COPY TO

From:	jian he <jian(dot)universality(at)gmail(dot)com>
To:	Junwang Zhao <zhjwpku(at)gmail(dot)com>
Cc:	Joe Conway <mail(at)joeconway(dot)com>, "Andrey M(dot) Borodin" <x4mmm(at)yandex-team(dot)ru>, Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>, Daniel Verite <daniel(at)manitou-mail(dot)org>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Davin Shearer <davin(at)apache(dot)org>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject:	Re: Emitting JSON to file using COPY TO
Date:	2026-01-21 12:15:25
Message-ID:	CACJufxGq6aJszBhfrUQKHeKmp0r+ka7=SwHSY7Qs_6LQMwiEbw@mail.gmail.com
Views:	Whole Thread | Raw Message | Download mbox | Resend email
Thread:	2023-11-25 19:21:37 from Davin Shearer <scholarsmate(at)gmail(dot)com>  2023-11-25 20:02:46 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>  2023-11-25 21:00:12 from Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>   2023-11-27 09:33:00 from Dominique Devienne <ddevienne(at)gmail(dot)com>    2023-11-27 09:44:55 from Dominique Devienne <ddevienne(at)gmail(dot)com>     2023-11-27 13:27:26 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>      2023-11-27 13:56:30 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>       2023-11-27 14:43:08 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>      2023-11-27 14:56:22 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>       2023-11-27 15:26:43 from Dominique Devienne <ddevienne(at)gmail(dot)com>        2023-11-28 07:36:32 from Filip Sedlák <filip(at)sedlakovi(dot)org>         2023-11-29 15:32:54 from Davin Shearer <davin(at)apache(dot)org>          2023-12-01 19:28:55 from Joe Conway <mail(at)joeconway(dot)com> 📎           2023-12-01 23:09:58 from Nathan Bossart <nathandbossart(at)gmail(dot)com>            2023-12-02 03:00:29 from Davin Shearer <davin(at)apache(dot)org>             2023-12-02 03:10:54 from Joe Conway <mail(at)joeconway(dot)com>            2023-12-02 14:31:46 from Joe Conway <mail(at)joeconway(dot)com>             2023-12-02 15:11:20 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>              2023-12-02 21:53:20 from Nathan Bossart <nathandbossart(at)gmail(dot)com>               2023-12-02 22:37:48 from Joe Conway <mail(at)joeconway(dot)com>                2023-12-03 14:53:49 from Joe Conway <mail(at)joeconway(dot)com> 📎              2023-12-09 11:56:23 from Hannu Krosing <hannuk(at)google(dot)com>           2023-12-02 18:50:12 from Maciek Sakrejda <m(dot)sakrejda(at)gmail(dot)com>            2023-12-02 22:43:52 from Joe Conway <mail(at)joeconway(dot)com>             2023-12-03 13:46:28 from Andrew Dunstan <andrew(at)dunslane(dot)net>           2023-12-03 15:10:38 from Andrew Dunstan <andrew(at)dunslane(dot)net>            2023-12-03 15:31:58 from Davin Shearer <davin(at)apache(dot)org>             2023-12-03 15:51:12 from Joe Conway <mail(at)joeconway(dot)com>              2023-12-03 22:38:28 from Davin Shearer <davin(at)apache(dot)org>               2023-12-04 01:14:31 from Joe Conway <mail(at)joeconway(dot)com>                2023-12-04 01:27:49 from Davin Shearer <davin(at)apache(dot)org>                2023-12-04 12:41:20 from Andrew Dunstan <andrew(at)dunslane(dot)net>                 2023-12-04 13:37:23 from Joe Conway <mail(at)joeconway(dot)com>                  2023-12-04 14:25:04 from Andrew Dunstan <andrew(at)dunslane(dot)net>                   2023-12-04 15:45:58 from Joe Conway <mail(at)joeconway(dot)com> 📎                    2023-12-04 18:37:06 from Davin Shearer <davin(at)apache(dot)org>                     2023-12-04 20:06:31 from Andrew Dunstan <andrew(at)dunslane(dot)net>                      2023-12-04 22:55:00 from Davin Shearer <davin(at)apache(dot)org>                       2023-12-05 02:54:50 from Joe Conway <mail(at)joeconway(dot)com> 📎                        2023-12-05 16:54:42 from Joe Conway <mail(at)joeconway(dot)com>                         2023-12-05 17:43:31 from Davin Shearer <davin(at)apache(dot)org>                          2023-12-05 18:51:22 from Joe Conway <mail(at)joeconway(dot)com> 📎                           2023-12-05 19:50:23 from Davin Shearer <davin(at)apache(dot)org>                            2023-12-05 20:55:53 from Andrew Dunstan <andrew(at)dunslane(dot)net>                             2023-12-05 21:02:06 from Joe Conway <mail(at)joeconway(dot)com>                              2023-12-05 21:09:13 from Joe Conway <mail(at)joeconway(dot)com>                               2023-12-05 21:20:11 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                2023-12-05 21:46:50 from Joe Conway <mail(at)joeconway(dot)com>                                 2023-12-05 23:45:24 from Davin Shearer <davin(at)apache(dot)org>                                 2023-12-06 12:36:36 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                  2023-12-06 13:49:13 from Joe Conway <mail(at)joeconway(dot)com> 📎                                   2023-12-06 15:32:41 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                    2023-12-06 16:15:39 from Joe Conway <mail(at)joeconway(dot)com>                                   2023-12-06 15:44:19 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                    2023-12-06 16:19:19 from Joe Conway <mail(at)joeconway(dot)com>                                     2023-12-06 16:26:35 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                    2023-12-06 16:19:54 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                     2023-12-06 16:28:33 from Sehrope Sarkuni <sehrope(at)jackdb(dot)com>                                      2023-12-06 21:28:59 from Joe Conway <mail(at)joeconway(dot)com>                                       2023-12-06 21:42:11 from Sehrope Sarkuni <sehrope(at)jackdb(dot)com>                                        2023-12-06 22:38:21 from Joe Conway <mail(at)joeconway(dot)com>                                         2023-12-06 22:56:22 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>                                          2023-12-07 13:19:19 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                     2023-12-06 16:28:59 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                      2023-12-06 16:33:49 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                                       2023-12-06 16:44:39 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                                        2023-12-06 19:48:52 from Joe Conway <mail(at)joeconway(dot)com>                                         2023-12-06 20:20:46 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                          2023-12-06 21:03:12 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                           2023-12-06 21:36:02 from Sehrope Sarkuni <sehrope(at)jackdb(dot)com>                                          2023-12-06 21:41:11 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                                          2023-12-07 02:56:22 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                                           2023-12-07 12:15:28 from Joe Conway <mail(at)joeconway(dot)com>                                2023-12-06 18:59:11 from "Daniel Verite" <daniel(at)manitou-mail(dot)org>                                 2023-12-06 19:47:25 from Joe Conway <mail(at)joeconway(dot)com>                                  2023-12-06 23:09:30 from Joe Conway <mail(at)joeconway(dot)com>                                   2023-12-06 23:28:06 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>                                    2023-12-06 23:38:32 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>                                     2023-12-06 23:48:54 from Joe Conway <mail(at)joeconway(dot)com>                                    2023-12-06 23:45:52 from Joe Conway <mail(at)joeconway(dot)com>                                     2023-12-07 00:39:11 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>                                      2023-12-07 00:57:42 from Joe Conway <mail(at)joeconway(dot)com>                                       2023-12-07 01:09:22 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>                                        2023-12-07 01:14:09 from Joe Conway <mail(at)joeconway(dot)com>                                         2023-12-07 01:21:28 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>                                   2023-12-07 01:10:21 from Joe Conway <mail(at)joeconway(dot)com> 📎                                    2023-12-07 13:35:52 from "Daniel Verite" <daniel(at)manitou-mail(dot)org>                                     2023-12-07 13:47:10 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>                                      2023-12-08 14:01:07 from Dave Cramer <davecramer(at)postgres(dot)rocks>                                       2023-12-08 20:35:39 from "Daniel Verite" <daniel(at)manitou-mail(dot)org>                                     2023-12-07 13:52:39 from Joe Conway <mail(at)joeconway(dot)com>                                      2023-12-07 13:56:41 from Joe Conway <mail(at)joeconway(dot)com>                                       2023-12-07 14:11:08 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>                                        2023-12-07 15:07:59 from Joe Conway <mail(at)joeconway(dot)com>                                    2023-12-08 19:45:23 from "Daniel Verite" <daniel(at)manitou-mail(dot)org>                                     2023-12-08 21:26:40 from Joe Conway <mail(at)joeconway(dot)com>                                    2024-01-08 19:36:34 from Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>                                     2024-01-08 20:40:23 from Joe Conway <mail(at)joeconway(dot)com>                                      2024-01-16 03:46:59 from jian he <jian(dot)universality(at)gmail(dot)com> 📎                                       2024-01-16 07:45:29 from jian he <jian(dot)universality(at)gmail(dot)com>                                      2024-03-08 17:28:04 from "Andrey M(dot) Borodin" <x4mmm(at)yandex-team(dot)ru>                                       2024-03-08 18:01:50 from Joe Conway <mail(at)joeconway(dot)com>                                        2024-03-09 01:13:34 from jian he <jian(dot)universality(at)gmail(dot)com>                                         2024-04-01 12:00:11 from jian he <jian(dot)universality(at)gmail(dot)com> 📎                                          2024-08-19 00:00:00 from jian he <jian(dot)universality(at)gmail(dot)com> 📎                                           2024-08-22 05:19:00 from jian he <jian(dot)universality(at)gmail(dot)com> 📎                                            2024-09-13 14:42:00 from jian he <jian(dot)universality(at)gmail(dot)com> 📎                                             2024-11-19 06:16:52 from jian he <jian(dot)universality(at)gmail(dot)com> 📎                                              2025-01-27 08:16:26 from jian he <jian(dot)universality(at)gmail(dot)com> 📎                                               2025-03-02 05:28:07 from Junwang Zhao <zhjwpku(at)gmail(dot)com> 📎                                                2025-03-11 08:23:42 from jian he <jian(dot)universality(at)gmail(dot)com> 📎                                                 2025-07-04 05:27:08 from jian he <jian(dot)universality(at)gmail(dot)com> 📎                                                  2025-08-10 15:20:12 from jian he <jian(dot)universality(at)gmail(dot)com> 📎                                                   2025-10-01 06:16:42 from jian he <jian(dot)universality(at)gmail(dot)com> 📎                                                    2025-11-10 00:53:02 from jian he <jian(dot)universality(at)gmail(dot)com> 📎                                                     2025-11-29 02:46:35 from jian he <jian(dot)universality(at)gmail(dot)com> 📎                                                      2026-01-21 12:15:25 from jian he <jian(dot)universality(at)gmail(dot)com> 📎                                    2024-01-19 08:09:47 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                     2024-01-23 05:31:00 from jian he <jian(dot)universality(at)gmail(dot)com> 📎                                      2024-01-27 05:55:23 from Junwang Zhao <zhjwpku(at)gmail(dot)com> 📎                                       2024-01-31 09:49:51 from vignesh C <vignesh21(at)gmail(dot)com>                                        2024-01-31 09:58:00 from Junwang Zhao <zhjwpku(at)gmail(dot)com>                                      2024-01-31 13:26:28 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                       2024-02-02 08:25:28 from jian he <jian(dot)universality(at)gmail(dot)com>                                        2024-02-02 09:47:59 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                         2024-02-02 10:05:53 from jian he <jian(dot)universality(at)gmail(dot)com>                                       2024-02-19 03:43:39 from jian he <jian(dot)universality(at)gmail(dot)com> 📎                                 2023-12-07 02:42:06 from "Euler Taveira" <euler(at)eulerto(dot)com>                              2023-12-05 21:12:00 from Andrew Dunstan <andrew(at)dunslane(dot)net>                               2023-12-05 21:15:29 from Joe Conway <mail(at)joeconway(dot)com>                       2023-12-05 14:56:03 from Andrew Dunstan <andrew(at)dunslane(dot)net>            2023-12-03 16:03:14 from Joe Conway <mail(at)joeconway(dot)com>             2023-12-03 17:11:34 from Joe Conway <mail(at)joeconway(dot)com>              2023-12-03 19:47:42 from Andrew Dunstan <andrew(at)dunslane(dot)net>             2023-12-03 19:24:53 from Joe Conway <mail(at)joeconway(dot)com>              2023-12-03 19:52:29 from Andrew Dunstan <andrew(at)dunslane(dot)net>               2023-12-03 20:09:36 from Joe Conway <mail(at)joeconway(dot)com>     2023-11-27 16:04:05 from Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>      2023-11-27 16:14:46 from Dominique Devienne <ddevienne(at)gmail(dot)com>
Lists:	pgsql-general pgsql-hackers

Attachment	Content-Type	Size
v22-0001-introduce-CopyFormat-refactor-CopyFormatOptions.patch	text/x-patch	13.1 KB
v22-0003-Add-option-force_array-for-COPY-JSON-FORMAT.patch	text/x-patch	9.7 KB
v22-0002-json-format-for-COPY-TO.patch	text/x-patch	21.9 KB

In response to

• Re: Emitting JSON to file using COPY TO at 2025-11-29 02:46:35 from jian he

Browse pgsql-general by date

	From	Date	Subject
Next Message	Adrian Klaver	2026-01-21 15:43:12	Re: pgBadger and postgres_fdw
Previous Message	Erik Wienhold	2026-01-21 09:14:02	Re: pg_trgm upgrade to 1.6 led to load average increase

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Xuneng Zhou	2026-01-21 12:40:16	Re: Add WALRCV_CONNECTING state to walreceiver
Previous Message	Zsolt Parragi	2026-01-21 12:13:04	Re: CREATE TABLE LIKE INCLUDING TRIGGERS