Re: New "single" COPY format

Поиск
Список
Период
Сортировка
От Aleksander Alekseev
Тема Re: New "single" COPY format
Дата
Msg-id CAJ7c6TMqSnQgGhFsg5VnMZ6EKaJzROQMro3YQ5EEyTzWgR89nw@mail.gmail.com
обсуждение исходный текст
Ответы Re: New "single" COPY format
Re: New "single" COPY format
Список pgsql-hackers
Hi Joel,

> Recap: This is about adding support to import/export text-based formats such as
> JSONL, or any unstructured text file, where wanting to import each line "as is"
> into a single column, or wanting to export a single column to a text file.

Sorry for being late for the discussion.

I disagree with the idea of adding a new format name for this. Mostly
because it is *not* a new format and pretending that it is will be
just a poor and/or confusing user interface.

IMO it should be 'text' we already have with special options e.g.
DELIMITER AS NULL ESCAPE AS NULL. If there are no escape characters
and column delimiters (and no NULLs designations, and what else I
forgot) then your text file just contains one tuple per line.

-- 
Best regards,
Aleksander Alekseev



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