Postgres Pro
Downloads
Home   >   mailing lists

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

From David G. Johnston
Subject Re: Emitting JSON to file using COPY TO
Date
Msg-id CAKFQuwbrNqsWcLrFcTurPOHtFQuCLWPk_6MLCrrVHhEp-wWJTw@mail.gmail.com
Whole thread Raw
In response to Emitting JSON to file using COPY TO  (Davin Shearer <scholarsmate@gmail.com>)
List pgsql-general
Tree view
On Sat, Nov 25, 2023 at 12:22 PM Davin Shearer <scholarsmate@gmail.com> wrote:

Is there a way to emit JSON results to file from within postgres?

Use psql to directly output query results to a file instead of using COPY to output structured output in a format you don't want.

David J.

pgsql-general by date:

Previous
From: Davin Shearer
Date:
Subject: Emitting JSON to file using COPY TO
Next
From: Adrian Klaver
Date:
Subject: Re: Emitting JSON to file using COPY TO