pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedCOPY FROM
2+ messages / 2 participants
[nested] [flat]
* COPY FROM
@ 2022-06-09 23:06 PG Doc comments form <noreply@postgresql.org>
0 siblings, 1 reply; 2+ messages in thread
From: PG Doc comments form @ 2022-06-09 23:06 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: irvin.solano.ny@gmail.com
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: COPY FROM
@ 2022-06-10 19:12 David G. Johnston <david.g.johnston@gmail.com>
parent: PG Doc comments form <noreply@postgresql.org>
0 siblings, 0 replies; 2+ messages in thread
From: David G. Johnston @ 2022-06-10 19:12 UTC (permalink / raw)
To: irvin.solano.ny@gmail.com, Pg Docs <pgsql-docs@lists.postgresql.org>
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2022-06-10 19:12 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-06-09 23:06 COPY FROM PG Doc comments form <noreply@postgresql.org>
2022-06-10 19:12 ` David G. Johnston <david.g.johnston@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox