/
n-dimens
/
pgloader
Обзор
Документация
Войти
/
n-dimens
/
pgloader
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
test/allcols.load
45 строк
974 B
Dimitri Fontaine
Review field to column projection code emitted.
10 ноя 2018, 22:22
10 ноя 2018, 22:22
656bf85
Код
Авторство
О чём код?
/* * This test is ported from pgloader 2.x where it was defined as: * * [allcols] * table = allcols * format = csv * filename = allcols/allcols.data * field_sep = : * columns = * * pg_option_work_mem = 14MB * */ LOAD CSV FROM inline (a, b, c) INTO postgresql:///pgloader?allcols (a, b, c text using (subseq c 0)) WITH fields optionally enclosed by '"', fields escaped by double-quote, fields terminated by ':' SET client_encoding to 'latin1', work_mem to '14MB', standard_conforming_strings to 'on' BEFORE LOAD DO $$ drop table if exists allcols; $$, $$ create table allcols ( a integer primary key, b date, c text ); $$; 1:2008-02-18:first entry 2:2008-02-19:second one 3:2008-02-20:another 4:2008-02-21:still running 5:2008-02-22:well, some more 6:2008-02-23:antepenultima 7:2008-02-24:next to last 8:2008-02-25:hey, it's today!