plpgsql copy import csv double quotes

Hi, MailingList

PG 9.3 under Ubuntu 14.04 (I know, that’s obsolete, but we’re planning to move to pg 10 or more during 2020)

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"

When I import this line in a table, with the exact column number, with the « copy » command in plpgslq, the import fails.

Saying that too many fields are present. 

I tried to catch the double quotes and delete then, but that’s hard under AWK or sed

_________________________________

Cordialement, Pascal CROZET

DBA - Qualis Consulting

• www.qualis-consulting.com • 04 78 22 74 90
• Le Bois des Côtes 1 – Bâtiment A
• 300 Route Nationale 6 – 69760 LIMONEST
_________________________________