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,
$ pwd: /var/www/html/mysql-postgres/pgloader-3.6.2/test/
Upload Files
File: /var/www/html/mysql-postgres/pgloader-3.6.2/test/csv-header.load
LOAD CSV
     FROM INLINE
     INTO postgresql:///pgloader?"group"

     WITH truncate,
          fields terminated by ',',
          csv header

   BEFORE LOAD DO
    $$ drop table if exists "group"; $$,
    $$ CREATE TABLE "group"
       (
          somefields     text,
          rekplcode      text,
          "repl$grpid"   text,
          "repl$id"      text,
          another        text,
          fields         integer
       )
    $$;


somefields,rekplcode,repl$grpid,repl$id,fields,another
a,b,c,d,1,e
foo,bar,baz,quux,2,foobar
@ Telegram