1LOAD CSV
2    FROM INLINE
3    INTO postgresql:///pgloader?nulls (f1, f2, f3)
4    WITH truncate,
5    	 keep unquoted blanks,
6         fields optionally enclosed by '"',
7         fields escaped by double-quote,
8         fields terminated by ','
9
10  BEFORE LOAD DO
11   $$ drop table if exists nulls; $$,
12   $$ create table if not exists nulls (id serial, f1 text, f2 text, f3 text); $$;
13
14"quoted empty string","","should be empty string"
15"no value between separators",,"should be null"
16"quoted blanks","    ","should be blanks"
17"unquoted blanks",    ,"should be null"
18"unquoted string",no quote,"should be 'no quote'"
19"quoted separator","a,b,c","should be 'a,b,c'"
20"keep extra blanks",  test string  , "should be an error"
21