On Fri, Jun 10, 2022 at 3:40 AM PG Doc comments form <nore...@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.