Postgres Pro
Downloads
Home   >   mailing lists

Re: plpgsql copy import csv double quotes - Mailing list pgsql-general

From Tom Lane
Subject Re: plpgsql copy import csv double quotes
Date
Msg-id 17097.1570660277@sss.pgh.pa.us
Whole thread Raw
In response to plpgsql copy import csv double quotes  (PASCAL CROZET <pascal.crozet@qualis-consulting.com>)
Responses RE: plpgsql copy import csv double quotes
List pgsql-general
Tree view 
PASCAL CROZET <pascal.crozet@qualis-consulting.com> writes:
> I’ve experience issues with double quotes \34 inside fields, in a csv file.

> Ex :
> "value1","some text","other text with "double quotes" inside","last field"

I don't know of any definition of CSV format by which that's legal data.
The typical rule is that double quotes that are data must be doubled;
at least, that's what COPY expects by default.  You can also get COPY
to handle variants like backslash-quote.

            regards, tom lane

pgsql-general by date:

Previous
From: Pól Ua Laoínecháin
Date:
Subject: Re: Is my lecturer wrong about PostgreSQL? I think he is!
Next
From: Thiemo Kellner
Date:
Subject: pgutils, pglogger and pgutilsL out