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:	2025-07-04 05:27:08
Message-ID:	CACJufxGK1WiwN48Srr6Si_XY4kz7SmDKBGxgyR3EE2WoeXJgFA@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> 📎                                                       2026-02-03 16:40:49 from Florents Tselai <florents(dot)tselai(at)gmail(dot)com>                                                        2026-02-06 03:26:04 from jian he <jian(dot)universality(at)gmail(dot)com> 📎                                                         2026-02-06 06:19:11 from Junwang Zhao <zhjwpku(at)gmail(dot)com>                                                         2026-02-07 13:27:29 from Junwang Zhao <zhjwpku(at)gmail(dot)com>                                                          2026-02-09 03:48:09 from jian he <jian(dot)universality(at)gmail(dot)com> 📎                                                           2026-03-04 15:51:14 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                                            2026-03-05 18:06:37 from Joe Conway <mail(at)joeconway(dot)com>                                                             2026-03-05 20:49:55 from Andrew Dunstan <andrew(at)dunslane(dot)net> 📎                                                              2026-03-06 09:38:30 from jian he <jian(dot)universality(at)gmail(dot)com> 📎                                                               2026-03-06 12:33:31 from Andrew Dunstan <andrew(at)dunslane(dot)net> 📎                                                                2026-03-08 16:16:08 from jian he <jian(dot)universality(at)gmail(dot)com> 📎                                                                 2026-03-08 19:44:51 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                                                  2026-03-09 03:48:26 from jian he <jian(dot)universality(at)gmail(dot)com> 📎                                                                   2026-03-09 12:23:09 from Andrew Dunstan <andrew(at)dunslane(dot)net> 📎                                                                   2026-03-16 18:24:58 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                                                    2026-03-16 20:59:56 from Andrew Dunstan <andrew(at)dunslane(dot)net> 📎                                                                     2026-03-17 17:50:35 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                                                      2026-03-17 19:49:39 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                                                     2026-03-18 14:37:23 from "Daniel Verite" <daniel(at)manitou-mail(dot)org>                                                                      2026-03-19 01:58:05 from jian he <jian(dot)universality(at)gmail(dot)com>                                                                       2026-03-19 15:02:21 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                                                        2026-03-19 16:06:13 from Joe Conway <mail(at)joeconway(dot)com>                                                                         2026-03-20 12:41:55 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                                                          2026-03-20 12:58:45 from Joe Conway <mail(at)joeconway(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
v17-0002-Add-option-force_array-for-COPY-JSON-FORMAT.patch	text/x-patch	9.8 KB
v17-0001-json-format-for-COPY-TO.patch	text/x-patch	30.5 KB

In response to

• Re: Emitting JSON to file using COPY TO at 2025-03-11 08:23:42 from jian he

Responses

• Re: Emitting JSON to file using COPY TO at 2025-08-10 15:20:12 from jian he

Browse pgsql-general by date

	From	Date	Subject
Next Message	shammat	2025-07-04 09:50:19	Re: Corrupt btree index includes rows that don't match
Previous Message	Erik Johnston	2025-07-03 17:07:43	Corrupt btree index includes rows that don't match

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Dilip Kumar	2025-07-04 05:33:31	Re: [PATCH] Allow parallelism for plpgsql return expression after commit 556f7b7
Previous Message	Pavel Stehule	2025-07-04 05:11:33	Re: proposal: plpgsql, new check for extra_errors - strict_expr_check