Re: Emitting JSON to file using COPY TO
| От | David G. Johnston |
|---|---|
| Тема | Re: Emitting JSON to file using COPY TO |
| Дата | |
| Msg-id | CAKFQuwaw+n=FBLUXs-jPQbcrvN9Bmgu6eTM-q+GpnHpKBDUsJg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Emitting JSON to file using COPY TO (Joe Conway <mail@joeconway.com>) |
| Ответы |
Re: Emitting JSON to file using COPY TO
|
| Список | pgsql-hackers |
On Wed, Dec 6, 2023 at 3:38 PM Joe Conway <mail@joeconway.com> wrote:
So the questions are:
1. Do those two formats work for the initial implementation?
Yes. We provide a stream-oriented format and one atomic-import format.
2. Is the default correct or should it be switched
e.g. rather than specifying FORCE_ARRAY to get an
array, something like FORCE_NO_ARRAY to get JSON lines
and the JSON array is default?
No default?
Require explicit of a sub-format when the main format is JSON.
JSON_OBJECT_ROWS
JSON_ARRAY_OF_OBJECTS
For a future compact array-structured-composites sub-format:
JSON_ARRAY_OF_ARRAYS
JSON_ARRAY_ROWS
David J.
В списке pgsql-hackers по дате отправления: