/
n-dimens
/
pgloader
Обзор
Документация
Войти
/
n-dimens
/
pgloader
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
test/csv-json.load
31 строка
1 KB
Dimitri Fontaine
Add support for explicit TARGET TABLE clause in load commands.
25 авг 2017, 02:57
25 авг 2017, 02:57
01e5c23
Код
Авторство
О чём код?
LOAD CSV FROM INLINE INTO postgresql:///pgloader TARGET TABLE json WITH truncate, fields not enclosed, fields terminated by '0x02', fields escaped by '0x02' BEFORE LOAD DO $$ drop table if exists json; $$, $$ CREATE TABLE json (json text); $$; {"table-name": "fetch","read":0,"imported":0,"errors":0,"time":"0.000s"} {"table-name": "fetch meta data","read":8,"imported":8,"errors":0,"time":"0.026s"} {"table-name": "create, truncate","read":0,"imported":0,"errors":0,"time":"0.046s"} {"table-name": "long","read":0,"imported":2,"errors":0,"time":"0.069s"} {"table-name": "blobs","read":0,"imported":1,"errors":0,"time":"0.021s"} {"table-name": "unsigned","read":0,"imported":2,"errors":0,"time":"0.007s"} {"table-name": "reals","read":0,"imported":3,"errors":0,"time":"0.007s"} {"table-name": "ints","read":0,"imported":3,"errors":0,"time":"0.006s"} {"table-name": "def","read":0,"imported":2,"errors":0,"time":"0.007s"} {"table-name": "stamps","read":0,"imported":2,"errors":0,"time":"0.007s"} {"table-name": "character","read":0,"imported":4,"errors":0,"time":"0.005s"} {"table-name": "index build completion","read":0,"imported":0,"errors":0,"time":"0.000s"} {"table-name": "Create Indexes","read":0,"imported":0,"errors":0,"time":"0.000s"} {"table-name": "Reset Sequences","read":0,"imported":0,"errors":0,"time":"0.015s"} {"table-name": "Total streaming time","read":0,"imported":19,"errors":0,"time":"0.216s"}