/
n-dimens
/
pgloader
Обзор
Документация
Войти
/
n-dimens
/
pgloader
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
test/simple.load
59 строк
1 KB
Dimitri Fontaine
Add sample data for fields escaped by double-quote.
29 апр 2018, 20:05
29 апр 2018, 20:05
1fe835d
Код
Авторство
О чём код?
/* * This test is ported from pgloader 2.x where it was defined as: * * [simple_tmpl] * template = True * format = text * datestyle = dmy * field_sep = | * trailing_sep = True * * [simple] * use_template = simple_tmpl * table = simple * filename = simple/simple.data * columns = a:1, b:3, c:2 * skip_head_lines = 2 * * # those reject settings are defaults one * reject_log = /tmp/simple.rej.log * reject_data = /tmp/simple.rej */ LOAD CSV FROM inline (a, c, b, trailing) INTO postgresql:///pgloader?simple (a, b, c) WITH truncate, skip header = 2, fields optionally enclosed by '"', fields escaped by double-quote, fields terminated by '|' SET client_encoding to 'latin1', datestyle to 'dmy', work_mem to '12MB', standard_conforming_strings to 'on' BEFORE LOAD DO $$ drop table if exists simple; $$, $$ create table simple ( a integer primary key, b date, c text ); $$; This is a stupid useless header like you sometime find in CSV files id|data|date| 1|some first row text|2006-11-11| 2|some second row text|13/11/2006| 3|some third row text|12-10-2006| 4|\ |2006-10-4| 5|some fifth row text|2006-5-12| 6|some sixth row text|10/7/6| 7|some null date to play with|| 8|"with embedded""quote"||