Re: Emitting JSON to file using COPY TO

On Wed, Jan 21, 2026 at 2:16 PM jian he <jian(dot)universality(at)gmail(dot)com> 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" ?