/
n-dimens
/
pgloader
Обзор
Документация
Войти
/
n-dimens
/
pgloader
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
test/bossa.load
25 строк
750 B
Dimitri Fontaine
Update an old archive test case.
28 авг 2016, 21:29
28 авг 2016, 21:29
0b06bc6
Код
Авторство
О чём код?
LOAD ARCHIVE FROM http://bossa.pl/pub/metastock/mstock/mstall.zip -- FROM /Users/dim/dev/temp/mstall.zip INTO postgresql:///stocks LOAD CSV FROM ALL FILENAMES MATCHING ~/ALIOR/ WITH ENCODING iso-8859-2 (ticker, quote_date, open, high, low, close, volume) INTO postgresql:///stocks?intf_stocks WITH SKIP HEADER=1, FIELDS OPTIONALLY ENCLOSED BY '"', FIELDS TERMINATED BY ',' AND LOAD CSV FROM ALL FILENAMES MATCHING ~/F[A-Z]{4}1[456]|OW20/ 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 ',' ;