1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
|
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"}
|
