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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
|
/*
* This test is ported from pgloader 2.x where it was defined as:
*
* [reformat]
* table = reformat
* format = text
* filename = reformat/reformat.data
* field_sep = |
* columns = id, timestamp
* reformat = timestamp:mysql:timestamp
*
*/
LOAD CSV
FROM inline (id, timestamp)
INTO postgresql:///pgloader?reformat
(
id,
timestamp timestamptz using (date-with-no-separator timestamp)
)
WITH fields optionally enclosed by '"',
fields escaped by double-quote,
fields terminated by '|'
SET client_encoding to 'latin1',
work_mem to '12MB',
standard_conforming_strings to 'on'
BEFORE LOAD DO
$$ drop table if exists reformat; $$,
$$ create table reformat (
id integer primary key,
timestamp timestamp with time zone
);
$$;
1|20071119150718
2|20041002153048
3|20060111060850
4|20060111060958
5|00000000000000
|
