Re: New "single" COPY format - Mailing list pgsql-hackers

From Aleksander Alekseev
Subject Re: New "single" COPY format
Date
Msg-id CAJ7c6TMqSnQgGhFsg5VnMZ6EKaJzROQMro3YQ5EEyTzWgR89nw@mail.gmail.com
Whole thread Raw
Responses Re: New "single" COPY format
List 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 by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Fix small typo, use InvalidRelFileNumber instead of InvalidOid
Next
From: Aleksander Alekseev
Date:
Subject: Re: New "single" COPY format