/
n-dimens
/
pgloader
Обзор
Документация
Войти
/
n-dimens
/
pgloader
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
test/parse/csv-with-projection.load
15 строк
465 B
Dimitri Fontaine
Port tests from pgloader 2.x, implement trailing-sep.
14 окт 2013, 00:10
14 окт 2013, 00:10
89aaabd
Код
Авторство
О чём код?
LOAD CSV FROM '*/GeoLiteCity-Blocks.csv' WITH ENCODING iso-646-us ( startIpNum, endIpNum, locId ) INTO postgresql://dim@localhost:54393/dim?geolite.blocks ( iprange ip4r using (ip-range startIpNum endIpNum), locId ) WITH truncate, skip header = 2, fields optionally enclosed by '"', fields escaped by backslash-quote, fields terminated by '\t';