HEX
Server: Apache/2.4.46 (Ubuntu)
System: Linux localhost 5.11.0-49-generic #55-Ubuntu SMP Wed Jan 12 17:36:34 UTC 2022 x86_64
User: root (0)
PHP: 7.4.16
Disabled: pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare,
Upload Files
File: /var/www/html/mysql-postgres/pgloader-3.6.2/test/csv-trim-extra-blanks.load
LOAD CSV
    FROM INLINE
    INTO postgresql:///pgloader?nulls (f1, f2, f3)
    WITH truncate,
    	 trim unquoted blanks,
         fields optionally enclosed by '"',
         fields escaped by double-quote,
         fields terminated by ','

  BEFORE LOAD DO
   $$ drop table if exists nulls; $$,
   $$ create table if not exists nulls (id serial, f1 text, f2 text, f3 text); $$;

"quoted empty string","","should be empty string"
"no value between separators",,"should be null"
"quoted blanks","    ","should be blanks"
"unquoted blanks",    ,"should be null"
"unquoted string",no quote,"should be 'no quote'"
"quoted separator","a,b,c","should be 'a,b,c'"
"trim extra blanks",  test string  , "should be 'test string'"