Search Postgresql Archives

Re: Emitting JSON to file using COPY TO

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 11/27/23 01:44, Dominique Devienne wrote:
On Mon, Nov 27, 2023 at 10:33 AM Dominique Devienne <ddevienne@xxxxxxxxx <mailto:ddevienne@xxxxxxxxx>> 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@xxxxxxxxxxx






[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux