Re: plpgsql copy import csv double quotes

2019-10-10 Thread pascal . crozet
TA/input/files/Extract_software.csv', > 't_m03_software', ',', 'HEADER'); > > > If the import fails, TRUNCATE isn't executed. The previous data's that > was in table remains the same. > > > *_____________* > > Cordialement

Re: plpgsql copy import csv double quotes

2019-10-10 Thread Adrian Klaver
't executed. The previous data's that was in table remains the same. *_* Cordialement, *Pascal CROZET** * *DBA * •www.qualis-consulting.com <http://www.qualis-consulting.com/>•04 78 22 74 90 •Le Bois des Côtes 1 – Bâtiment A •300 Route Nationale 6 – 69760 LIMONEST *

RE: plpgsql copy import csv double quotes

2019-10-10 Thread PASCAL CROZET
't executed. The previous data's that was in table remains the same. _ Cordialement, Pascal CROZET DBA • www.qualis-consulting.com<http://www.qualis-consulting.com/> • 04 78 22 74 90 • Le Bois des Côtes 1 – Bâtiment A • 300 Route Nationale 6 – 69760 LIMONEST _ _

Re: plpgsql copy import csv double quotes

2019-10-09 Thread Tom Lane
PASCAL CROZET 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

Re: plpgsql copy import csv double quotes

2019-10-09 Thread Adrian Klaver
On 10/9/19 2:20 PM, PASCAL CROZET wrote: 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 "doubl