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/bossa-all.load

/*
 * We load all the files in the archive, all of them into the same target table.
 */

load archive
     from http://bossa.pl/pub/futures/mstock/mstfut.zip

  load csv
    from all filenames matching ~/./
      with encoding iso-8859-2
      ( ticker
      , quote_date
      , open
      , high
      , low
      , close
      , volume
      , openint
      )
    into postgresql:///stocks?intf_derivatives
    with
      skip header=1
    , fields optionally enclosed by '"'
    , fields terminated by ','
    , truncate;