On Sat, Nov 25, 2023 at 10:00 PM Adrian Klaver <adrian.kla...@aklaver.com> wrote:
> On 11/25/23 11:21, Davin Shearer wrote: > > Hello! > > > > I'm trying to emit a JSON aggregation of JSON rows to a file using COPY > > TO, but I'm running into problems with COPY TO double quoting the > > output. Here is a minimal example that demonstrates the problem I'm > > having: > > > > > I have tried to get COPY TO to copy the results to file "as-is" by > > setting the escape and the quote characters to the empty string (''), > > but they only apply to the CSV format. > > > > Is there a way to emit JSON results to file from within postgres? > > Effectively, nn "as-is" option to COPY TO would work well for this JSON > > use case. > > > > Not using COPY. > > See David Johnson's post for one way using the client psql. > > Otherwise you will need to use any of the many ETL programs out there > that are designed for this sort of thing. > Guys, I don't get answers like that. The JSON spec is clear: >