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