Re: Should CSV parsing be stricter about mid-field quotes? - Mailing list pgsql-hackers

From Daniel Verite
Subject Re: Should CSV parsing be stricter about mid-field quotes?
Date
Msg-id 0e0ce40e-819f-46d8-99d4-251524e9e0e8@manitou-mail.org
Whole thread Raw
In response to Re: Should CSV parsing be stricter about mid-field quotes?  ("Joel Jacobson" <joel@compiler.org>)
List pgsql-hackers
    Joel Jacobson wrote:

> - No Headers or Metadata:

It's not clear why it's necessary to disable the HEADER option
for this format?

>  The format does not support header rows or end-of-data markers;
>  every line is treated as data.

With COPY FROM STDIN followed by inline data in a script,
an end-of-data marker is required.  That's also a problem
for CSV except it's mitigated by the possibility of quoting
(using "\." instead of \.)


Best regards,
--
Daniel Vérité
https://postgresql.verite.pro/
Twitter: @DanielVerite



pgsql-hackers by date:

Previous
From: Fredrik Widlert
Date:
Subject: Re: Pg17 Crash in Planning (Arrays + Casting + UDF)
Next
From: jian he
Date:
Subject: Re: ALTER TABLE ONLY .. DROP CONSTRAINT on partitioned tables