/
n-dimens
/
pgloader
Обзор
Документация
Войти
/
n-dimens
/
pgloader
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
test/reformat.load
46 строк
998 B
Dimitri Fontaine
Improve database connection parsing to use sensible defaults.
20 окт 2013, 00:39
20 окт 2013, 00:39
f619054
Код
Авторство
О чём код?
/* * This test is ported from pgloader 2.x where it was defined as: * * [reformat] * table = reformat * format = text * filename = reformat/reformat.data * field_sep = | * columns = id, timestamp * reformat = timestamp:mysql:timestamp * */ LOAD CSV FROM inline (id, timestamp) INTO postgresql:///pgloader?reformat ( id, timestamp timestamptz using (date-with-no-separator timestamp) ) 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 reformat; $$, $$ create table reformat ( id integer primary key, timestamp timestamp with time zone ); $$; 1|20071119150718 2|20041002153048 3|20060111060850 4|20060111060958 5|00000000000000