/
n-dimens
/
pgloader
Обзор
Документация
Войти
/
n-dimens
/
pgloader
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
test/csv-hstore.load
29 строк
685 B
Dimitri Fontaine
Don't double-quote identifiers in catalog queries.
10 янв 2017, 23:12
10 янв 2017, 23:12
dbf7d6e
Код
Авторство
О чём код?
LOAD CSV FROM INLINE INTO postgresql://dim@localhost/pgloader?public."HS" WITH truncate, fields terminated by '\t', fields not enclosed, fields escaped by backslash-quote, quote identifiers SET work_mem to '128MB', standard_conforming_strings to 'on', application_name to 'my app name' BEFORE LOAD DO $$ create extension if not exists hstore; $$, $$ drop table if exists "HS"; $$, $$ CREATE TABLE "HS" ( id serial primary key, kv hstore ) $$; 1 email=>foo@example.com,a=>b 2 test=>value 3 a=>b,c=>"quoted hstore value",d=>other 4 baddata