Re: COPY FROM

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: COPY FROM
Дата
Msg-id CAKFQuwasdFvX8R99o3s+QHg707mihFRfJwUz0Q_8WSMbg=FN0Q@mail.gmail.com
обсуждение исходный текст
Ответ на COPY FROM  (PG Doc comments form <noreply@postgresql.org>)
Список 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 по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: correction
Следующее
От: PG Doc comments form
Дата:
Сообщение: Didn't correct output for LTRIM function