/
n-dimens
/
pgloader
Обзор
Документация
Войти
/
n-dimens
/
pgloader
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
test/udc.load
50 строк
994 B
Dimitri Fontaine
Improve parsing of list separating commas wrt to whitespacing.
24 ноя 2013, 00:49
24 ноя 2013, 00:49
ea4e74e
Код
Авторство
О чём код?
/* * This test is ported from pgloader 2.x where it was defined as: * * [udc] * table = udc * format = text * filename = udc/udc.data * input_encoding = 'latin1' * field_sep = % * columns = b:2, d:1, x:3, y:4 * udc_c = constant value * copy_columns = b, c, d * */ LOAD CSV FROM inline WITH ENCODING latin1 (d, b, x, y) INTO postgresql:///pgloader?udc ( b , c text using "constant value" , d ) WITH fields optionally enclosed by '"', fields escaped by double-quote, fields terminated by '%' SET client_encoding to 'latin1', work_mem to '12MB', standard_conforming_strings to 'on' BEFORE LOAD DO $$ drop table if exists udc; $$, $$ create table udc ( b integer primary key, c text, d integer ); $$; 1%5%foo%bar 2%10%bar%toto 3%4%toto%titi 4%18%titi%baz 5%2%baz%foo