COPY FROM

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: irvin(dot)solano(dot)ny(at)gmail(dot)com
Subject: COPY FROM
Date: 2022-06-09 23:06:08
Message-ID: 165481596844.573547.14869130986898271050@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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.

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message David G. Johnston 2022-06-09 23:18:07 Re: correction
Previous Message Bruce Momjian 2022-06-08 19:07:01 Re: Unclear Wording