Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1q1C5A-0005Pl-Tq
	for pgsql-hackers@arkaria.postgresql.org; Mon, 22 May 2023 20:24:40 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1q1C58-00045V-8M
	for pgsql-hackers@arkaria.postgresql.org; Mon, 22 May 2023 20:24:38 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <daniel@manitou-mail.org>)
	id 1q1C57-00045M-Vd
	for pgsql-hackers@lists.postgresql.org; Mon, 22 May 2023 20:24:37 +0000
Received: from mail.verite.pro ([185.16.44.216])
	by magus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <daniel@manitou-mail.org>)
	id 1q1C50-001Upt-GS
	for pgsql-hackers@lists.postgresql.org; Mon, 22 May 2023 20:24:37 +0000
Received: by mail.verite.pro (Postfix, from userid 1000)
	id CA8AD8C06E4; Mon, 22 May 2023 22:24:29 +0200 (CEST)
Content-Type: text/plain; charset="iso-8859-15"
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
Subject: Re: Should CSV parsing be stricter about mid-field quotes?
From: "Daniel Verite" <daniel@manitou-mail.org>
To: "Kirk Wolak" <wolakk@gmail.com>
Cc: Joel Jacobson <joel@compiler.org>,
 Andrew Dunstan <andrew@dunslane.net>,
 pgsql-hackers@lists.postgresql.org
In-Reply-To: <CACLU5mRj48yYnEj7k3xYFbsNkgG5NsZO7NxQQLM03G9HHQYuqw@mail.gmail.com>
Date: Mon, 22 May 2023 22:24:27 +0200
Message-Id: <76f3cb5c-b524-4488-9a01-766dac980f73@manitou-mail.org>
X-Mailer: Manitou v1.7.3
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: <https://www.postgresql.org/message-id/76f3cb5c-b524-4488-9a01-766dac980f73%40manitou-mail.org>
Precedence: bulk

	Kirk Wolak wrote:

> We do NOT do "CSV", we mimic pg_dump.

pg_dump uses the text format (as opposed to csv), where
\. on a line by itself cannot appear in the data, so there's
no problem. The problem is limited to the csv format.


Best regards,
--=20
Daniel V=E9rit=E9
https://postgresql.verite.pro/
Twitter: @DanielVerite