Re: COPY FROM - Mailing list pgsql-docs

From David G. Johnston
Subject Re: COPY FROM
Date
Msg-id CAKFQuwasdFvX8R99o3s+QHg707mihFRfJwUz0Q_8WSMbg=FN0Q@mail.gmail.com
Whole thread Raw
In response to COPY FROM  (PG Doc comments form <noreply@postgresql.org>)
List pgsql-docs
On Fri, Jun 10, 2022 at 3:40 AM PG Doc comments form <noreply@postgresql.org> wrote:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/14/sql-copy.html
Description:

When copying a csv file into a table, ifthere is a string missing a double
quote in the end, COPY will return an error saying the string is infinitely
long.  But placing quote '''' (quote and four single quotes) resolves the
issue.  The documentation does not explain why that mechanism would work,
and instead refers to fixing the csv file.

You might want to explain this with examples.  Even if what you are saying works at face value it seems more likely accidental rather than something we'd want to document.  Or, it falls under "fixing the csv file" - the details of which we are unlikely to try and describe.

David J.

pgsql-docs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: correction
Next
From: PG Doc comments form
Date:
Subject: Didn't correct output for LTRIM function