mirror of
https://github.com/dimitri/pgloader.git
synced 2025-08-07 23:07:00 +02:00
26 lines
526 B
Fish
26 lines
526 B
Fish
/*
|
|
* 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;
|