Re: Emitting JSON to file using COPY TO

Поиск
Список
Период
Сортировка
От Maciek Sakrejda
Тема Re: Emitting JSON to file using COPY TO
Дата
Msg-id CAOtHd0C+k8M1HYPubnH6J_7B5Eh5_nrun-n3fc9ZsSb_Tq9ZHA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Emitting JSON to file using COPY TO  (Joe Conway <mail@joeconway.com>)
Ответы Re: Emitting JSON to file using COPY TO  (Joe Conway <mail@joeconway.com>)
Список pgsql-hackers
On Fri, Dec 1, 2023 at 11:32 AM Joe Conway <mail@joeconway.com> wrote:
> 1. Is supporting JSON array format sufficient, or does it need to
> support some other options? How flexible does the support scheme need to be?

"JSON Lines" is a semi-standard format [1] that's basically just
newline-separated JSON values. (In fact, this is what
log_destination=jsonlog gives you for Postgres logs, no?) It might be
worthwhile to support that, too.

[1]: https://jsonlines.org/



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Paul Jungwirth
Дата:
Сообщение: Re: SQL:2011 application time
Следующее
От: Rafael Thofehrn Castro
Дата:
Сообщение: Proposal: In-flight explain logging