1LOAD CSV 2 FROM INLINE with encoding 'ascii' 3 INTO postgresql:///pgloader 4 TARGET TABLE jordane 5 6 WITH truncate, 7 fields terminated by '|', 8 fields not enclosed, 9 fields escaped by backslash-quote 10 11 SET work_mem to '128MB', 12 standard_conforming_strings to 'on' 13 14 BEFORE LOAD DO 15 $$ drop table if exists jordane; $$, 16 $$ CREATE TABLE jordane 17 ( 18 "NOM" character(20), 19 "PRENOM" character(20) 20 ) 21 $$; 22 23BORDET|Jordane 24BORDET|Audrey 25LASTNAME|"opening quote 26BONNIER|testprenombe~aucouptroplong 27JOURDAIN|héhé¶ 28