/
n-dimens
/
pgloader
Обзор
Документация
Войти
/
n-dimens
/
pgloader
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
test/csv-keep-extra-blanks.load
20 строк
717 B
Dimitri Fontaine
Switch to the newer cl-csv API.
11 янв 2014, 21:28
11 янв 2014, 21:28
07c614c
Код
Авторство
О чём код?
LOAD CSV FROM INLINE INTO postgresql:///pgloader?nulls (f1, f2, f3) WITH truncate, keep unquoted blanks, fields optionally enclosed by '"', fields escaped by double-quote, fields terminated by ',' BEFORE LOAD DO $$ drop table if exists nulls; $$, $$ create table if not exists nulls (id serial, f1 text, f2 text, f3 text); $$; "quoted empty string","","should be empty string" "no value between separators",,"should be null" "quoted blanks"," ","should be blanks" "unquoted blanks", ,"should be null" "unquoted string",no quote,"should be 'no quote'" "quoted separator","a,b,c","should be 'a,b,c'" "keep extra blanks", test string , "should be an error"