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
47
48
49
50
|
/*
* This test is ported from pgloader 2.x where it was defined as:
*
* [udc]
* table = udc
* format = text
* filename = udc/udc.data
* input_encoding = 'latin1'
* field_sep = %
* columns = b:2, d:1, x:3, y:4
* udc_c = constant value
* copy_columns = b, c, d
*
*/
LOAD CSV
FROM inline WITH ENCODING latin1
(d, b, x, y)
INTO postgresql:///pgloader?udc
(
b
, c text using "constant value"
, d
)
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 udc; $$,
$$ create table udc (
b integer primary key,
c text,
d integer
);
$$;
1%5%foo%bar
2%10%bar%toto
3%4%toto%titi
4%18%titi%baz
5%2%baz%foo
|
