From: Adrian Klaver <adrian.klaver@aklaver.com>
To: Davin Shearer <scholarsmate@gmail.com>
To: pgsql-general@lists.postgresql.org
Subject: Re: Emitting JSON to file using COPY TO
Date: Sat, 25 Nov 2023 13:00:12 -0800
Message-ID: <fc1e39f8-274f-4be6-8a70-9fb0d9fe84a2@aklaver.com> (raw)
In-Reply-To: <CALvfUkBxTYy5uWPFVwpk_7ii2zgT07t3d-yR_cy4sfrrLU=kcg@mail.gmail.com>
References: <CALvfUkBxTYy5uWPFVwpk_7ii2zgT07t3d-yR_cy4sfrrLU=kcg@mail.gmail.com>
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.
> Any assistance would be appreciated.
>
> Thanks,
> Davin
--
Adrian Klaver
adrian.klaver@aklaver.com
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: pgsql-general@postgresql.org
Cc: adrian.klaver@aklaver.com, scholarsmate@gmail.com, pgsql-general@lists.postgresql.org
Subject: Re: Emitting JSON to file using COPY TO
In-Reply-To: <fc1e39f8-274f-4be6-8a70-9fb0d9fe84a2@aklaver.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox