Re: Emitting JSON to file using COPY TO
От
Adrian Klaver
Тема
Re: Emitting JSON to file using COPY TO
Дата
Msg-id
a270aba3-899c-4972-b9b8-95a6228626e4@aklaver.com
Ответ на
Re: Emitting JSON to file using COPY TO (Dominique Devienne)
Список
Дерево обсуждения
Emitting JSON to file using COPY TO Davin Shearer <scholarsmate@gmail.com>
Re: Emitting JSON to file using COPY TO "David G. Johnston" <david.g.johnston@gmail.com>
Re: Emitting JSON to file using COPY TO Adrian Klaver <adrian.klaver@aklaver.com>
Re: Emitting JSON to file using COPY TO Dominique Devienne <ddevienne@gmail.com>
Re: Emitting JSON to file using COPY TO Dominique Devienne <ddevienne@gmail.com>
Re: Emitting JSON to file using COPY TO Adrian Klaver <adrian.klaver@aklaver.com>
Re: Emitting JSON to file using COPY TO Dominique Devienne <ddevienne@gmail.com>
Re: Emitting JSON to file using COPY TO "David G. Johnston" <david.g.johnston@gmail.com>
Re: Emitting JSON to file using COPY TO Tom Lane <tgl@sss.pgh.pa.us>
Re: Emitting JSON to file using COPY TO Dominique Devienne <ddevienne@gmail.com>
Re: Emitting JSON to file using COPY TO Filip Sedlák <filip@sedlakovi.org>
Re: Emitting JSON to file using COPY TO Davin Shearer <davin@apache.org>
Re: Emitting JSON to file using COPY TO Pavel Stehule <pavel.stehule@gmail.com>
Re: Emitting JSON to file using COPY TO "David G. Johnston" <david.g.johnston@gmail.com>
On 11/27/23 01:44, Dominique Devienne wrote: > On Mon, Nov 27, 2023 at 10:33 AM Dominique Devienne > wrote: > > On second thought, I guess that's COPY in its text modes doing the escaping? > Interesting. The text-based modes of COPY are configurable. There's even > a JSON mode. Where are you seeing the JSON mode for COPY? AFAIK there is only text and CSV formats. > By miracle, would the JSON output mode recognize JSON[B] values, and > avoid the escaping? > > -- Adrian Klaver adrian.klaver@aklaver.com
В списке pgsql-general по дате отправления
От: Adrian Klaver
Дата:
