Postgres Pro
Downloads
Home   >   mailing lists

Re: Emitting JSON to file using COPY TO - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Emitting JSON to file using COPY TO
Date
Msg-id a270aba3-899c-4972-b9b8-95a6228626e4@aklaver.com
Whole thread Raw
In response to Re: Emitting JSON to file using COPY TO  (Dominique Devienne <ddevienne@gmail.com>)
Responses Re: Emitting JSON to file using COPY TO
List pgsql-general
Tree view 
On 11/27/23 01:44, Dominique Devienne wrote:
> On Mon, Nov 27, 2023 at 10:33 AM Dominique Devienne <ddevienne@gmail.com 
> <mailto:ddevienne@gmail.com>> 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 by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Parallel Index Scan Implementation
Next
From: Adrian Klaver
Date:
Subject: Re: Could not read from file "pg_subtrans/00F5" at offset 122880: Success.