MIME-Version: 1.0
References: <b3a73eca-ec3b-4b64-b6c2-82418bb16701@manitou-mail.org>
 <b7d8c88b-d175-44ca-a323-ec2f5c3cd37d@joeconway.com> <8620df11-96e4-4ca3-8f3c-33a479260961@joeconway.com>
 <4162f7f7-6fd6-4720-98e2-89f80e3de2ed@joeconway.com> <CAEZATCWh29787xf=4NgkoixeqRHrqi0Qd33Z6_-F8t2dZ0yLCQ@mail.gmail.com>
 <153b71b8-b6fb-4930-aaff-a7334cb3f6d6@joeconway.com> <CC6F036C-08BB-4A7B-ACBF-F99393E8A492@yandex-team.ru>
 <8ef5f5d6-38db-4624-8eef-2d96c9eba9d4@joeconway.com> <CACJufxGMSbpXCCoCb_u5EULo5y2sfMgASkRk2pmw9WRu2qOCXw@mail.gmail.com>
 <CACJufxGjJXKfPZoyFqgvYTBYW3GmB5WA+0H0zXkfYjrc7au7qg@mail.gmail.com>
 <CACJufxET6LJWbywU_odC_k3vYwEKhNQjiWTDk=37ecQG5mFk5Q@mail.gmail.com>
 <CACJufxFvOQWcGpiaFkOxMGPc=g85h=-LdyB_2wXBSVQCO9RAHQ@mail.gmail.com>
 <CACJufxH=3PreKDHuoskn0GQmxUcw-n0k3ogN1CD4CvFbLBy-VA@mail.gmail.com>
 <CACJufxH8J0uD-inukxAmd3TVwt-b-y7d7hLGSBdEdLXFGJLyDA@mail.gmail.com>
 <CACJufxG_VY-Hv6ss8pqDxP8SaBmBPYUdv=LB3QFpsqtTZu9FYQ@mail.gmail.com>
 <CAEG8a3J=Wb0dv4uwhhMXQBNPfZ63_ZaSdko8-chK-tc-wSAwog@mail.gmail.com>
 <CACJufxGmSw5GUOquAT+q7B0k+xweU3NwcNc53fLjHQjsMeanaw@mail.gmail.com>
 <CACJufxGK1WiwN48Srr6Si_XY4kz7SmDKBGxgyR3EE2WoeXJgFA@mail.gmail.com>
 <CACJufxGF0F8ooTCCaY=PLhb-K84NOz=SYGjYF8ZrbgO8C0iFqQ@mail.gmail.com>
 <CACJufxGbiNtsHnn=ZGw2J4VcjD5za5znbcxsaEvVd7vMdxQQ+g@mail.gmail.com>
 <CACJufxG7T2_LF=UuJ4iFYMJZsK37L6d3XJvBrcR-3Pp3z+BiGw@mail.gmail.com>
 <CACJufxG0=CoG64Ng7DfMP4zy0MORhTW7rRioQnNVCw-6GxRaXg@mail.gmail.com> <CACJufxGq6aJszBhfrUQKHeKmp0r+ka7=SwHSY7Qs_6LQMwiEbw@mail.gmail.com>
In-Reply-To: <CACJufxGq6aJszBhfrUQKHeKmp0r+ka7=SwHSY7Qs_6LQMwiEbw@mail.gmail.com>
From: Florents Tselai <florents.tselai@gmail.com>
Date: Tue, 3 Feb 2026 18:40:49 +0200
Message-ID: <CA+v5N43-F9-Wiktg_-+aqKJz+YiCNJMAh5ootDeTKkOJ=kiaHA@mail.gmail.com>
Subject: Re: Emitting JSON to file using COPY TO
To: jian he <jian.universality@gmail.com>
Cc: Junwang Zhao <zhjwpku@gmail.com>, Joe Conway <mail@joeconway.com>, 
	"Andrey M. Borodin" <x4mmm@yandex-team.ru>, Dean Rasheed <dean.a.rasheed@gmail.com>, 
	Daniel Verite <daniel@manitou-mail.org>, Andrew Dunstan <andrew@dunslane.net>, 
	Davin Shearer <davin@apache.org>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000059a40b0649ee1c5c"
Archived-At: <https://www.postgresql.org/message-id/CA%2Bv5N43-F9-Wiktg_-%2BaqKJz%2BYiCNJMAh5ootDeTKkOJ%3DkiaHA%40mail.gmail.com>
Precedence: bulk

--00000000000059a40b0649ee1c5c
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Wed, Jan 21, 2026 at 2:16=E2=80=AFPM jian he <jian.universality@gmail.co=
m> wrote:

> hi.
>
> rebase only.
>
> --
> jian
> https://www.enterprisedb.com/


I (and others I assume) would really like to see this in 19;
glancing at the thread above and in the test cases I see this is in good
shape for comitter review.
No?

If I were to add something  it would be an example in copy.sgml
  <para>
   When the <literal>FORCE_ARRAY</literal> option is enabled,
   the entire output is wrapped in a JSON array and individual rows are
separated by commas:
   <programlisting>
COPY (SELECT id, name FROM users) TO STDOUT (FORMAT JSON, FORCE_ARRAY);
   </programlisting>
   <programlisting>
[
{"id": 1, "name": "Alice"}
,{"id": 2, "name": "Bob"}
,{"id": 3, "name": "Charlie"}
]
   </programlisting>
  </para>

Also, apologies if that has been discussed already,
is there a good reason why didn't we just go with a simple "WRAP_ARRAY" ?

--00000000000059a40b0649ee1c5c
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div><br></div><div><div dir=3D"ltr" clas=
s=3D"gmail_signature"><div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><d=
iv dir=3D"ltr"><p style=3D"font-size:12.8px;line-height:1.38;margin-top:0pt=
;margin-bottom:0pt"></p></div></div></div></div></div></div><br></div><br><=
div class=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr" class=3D"g=
mail_attr">On Wed, Jan 21, 2026 at 2:16=E2=80=AFPM jian he &lt;<a href=3D"m=
ailto:jian.universality@gmail.com">jian.universality@gmail.com</a>&gt; wrot=
e:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0=
.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(20=
4,204,204);padding-left:1ex">hi.<br>
<br>
rebase only.<br>
<br>
--<br>
jian<br>
<a href=3D"https://www.enterprisedb.com/" rel=3D"noreferrer" target=3D"_bla=
nk">https://www.enterprisedb.com/</a></blockquote><div><br></div><div>I (an=
d others I assume) would really like to see this in 19;</div><div>glancing =
at the thread above and in the test cases I see this is in good shape for c=
omitter review.</div><div>No?=C2=A0</div><div><br></div><div>If I were to a=
dd something =C2=A0it would be an example in copy.sgml=C2=A0</div><div>=C2=
=A0 &lt;para&gt;<br>=C2=A0 =C2=A0When the &lt;literal&gt;FORCE_ARRAY&lt;/li=
teral&gt; option is enabled,<br>=C2=A0 =C2=A0the entire output is wrapped i=
n a JSON array and individual rows are separated by commas:<br>=C2=A0 =C2=
=A0&lt;programlisting&gt;<br>COPY (SELECT id, name FROM users) TO STDOUT (F=
ORMAT JSON, FORCE_ARRAY);<br>=C2=A0 =C2=A0&lt;/programlisting&gt;<br>=C2=A0=
 =C2=A0&lt;programlisting&gt;<br>[<br>{&quot;id&quot;: 1, &quot;name&quot;:=
 &quot;Alice&quot;}<br>,{&quot;id&quot;: 2, &quot;name&quot;: &quot;Bob&quo=
t;}<br>,{&quot;id&quot;: 3, &quot;name&quot;: &quot;Charlie&quot;}<br>]<br>=
=C2=A0 =C2=A0&lt;/programlisting&gt;<br>=C2=A0 &lt;/para&gt;<br></div><div>=
<br></div><div>Also, apologies if that has been discussed already,</div><di=
v>is there a good reason why didn&#39;t we just go with a simple &quot;WRAP=
_ARRAY&quot; ?=C2=A0</div><div><br></div></div></div>

--00000000000059a40b0649ee1c5c--