/
n-dimens
/
pgloader
Обзор
Документация
Войти
/
n-dimens
/
pgloader
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
test/fixed.load
53 строки
1 KB
Dimitri Fontaine
Add support for explicit TARGET TABLE clause in load commands.
25 авг 2017, 02:57
25 авг 2017, 02:57
01e5c23
Код
Авторство
О чём код?
/* * This test is ported from pgloader 2.x where it was defined as: * * [fixed] * table = fixed * format = fixed * filename = fixed/fixed.data * columns = * * fixed_specs = a:0:10, b:10:8, c:18:8, d:26:17 * reformat = c:pgtime:time * */ LOAD FIXED FROM inline ( a from 0 for 10, b from 10 for 8, c from 18 for 8, d from 26 for 17 [null if blanks, trim right whitespace] ) INTO postgresql:///pgloader TARGET TABLE fixed ( a, b, c time using (time-with-no-separator c), d ) WITH truncate, drop indexes SET client_encoding to 'latin1', work_mem to '14MB', standard_conforming_strings to 'on' BEFORE LOAD DO $$ drop table if exists fixed; $$, $$ create table fixed ( a integer primary key, b date, c time, d text ); $$; 01234567892008052011431250firstline 01234562008052115182300left blank-padded 12345678902008052208231560another line 2345609872014092914371500 2345678902014092914371520