public inbox for [email protected]
help / color / mirror / Atom feedFrom: David G. Johnston <[email protected]>
To: Pavel Stehule <[email protected]>
Cc: Dominique Devienne <[email protected]>
Cc: Adrian Klaver <[email protected]>
Cc: Davin Shearer <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Emitting JSON to file using COPY TO
Date: Mon, 27 Nov 2023 07:43:08 -0700
Message-ID: <CAKFQuwa=tVQxe0m6tnW-BtLhsGJN0ympLP=WiP+bsbavQU2w4A@mail.gmail.com> (raw)
In-Reply-To: <CAFj8pRD-vEAXNew6wu0j9ARhQ_Hu0nwFmGQj0YMQiWw5rQDciQ@mail.gmail.com>
References: <CALvfUkBxTYy5uWPFVwpk_7ii2zgT07t3d-yR_cy4sfrrLU=kcg@mail.gmail.com>
<[email protected]>
<CAFCRh-_LhP5Ln4-beVz=1pQ9VycU3hAxnJHXhPHZRmX0BSCVEQ@mail.gmail.com>
<CAFCRh--Vhx0105S7SWAYHGcVMTSRtbcoArDUGSbYSWRUGunW_g@mail.gmail.com>
<CAKFQuwZb3zaSqkOvGXRRLZEW61az+4xyHZ7tBPR91JfrcdCKvA@mail.gmail.com>
<CAFj8pRD-vEAXNew6wu0j9ARhQ_Hu0nwFmGQj0YMQiWw5rQDciQ@mail.gmail.com>
On Monday, November 27, 2023, Pavel Stehule <[email protected]> wrote:
> Hi
>
> po 27. 11. 2023 v 14:27 odesílatel David G. Johnston <
> [email protected]> napsal:
>
>> On Monday, November 27, 2023, Dominique Devienne <[email protected]>
>> wrote:
>>
>>> There's even a JSON mode.
>>> By miracle, would the JSON output mode recognize JSON[B] values, and
>>> avoid the escaping?
>>>
>>
>> I agree there should be a copy option for “not formatted” so if you dump
>> a single column result in that format you get the raw unescaped contents of
>> the column. As soon as you ask for a format your json is now embedded so it
>> is a value within another format and any structural aspects of the wrapper
>> present in the json text representation need to be escaped.
>>
>
> Is it better to use the LO API for this purpose? It is native for not
> formatted data.
>
Using LO is, IMO, never the answer. But if you are using a driver API
anyway just handle the normal select query result.
David J.
view thread (35+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: Emitting JSON to file using COPY TO
In-Reply-To: <CAKFQuwa=tVQxe0m6tnW-BtLhsGJN0ympLP=WiP+bsbavQU2w4A@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox