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
|
/*
* This test is ported from pgloader 2.x where it was defined as:
*
* [allcols]
* table = allcols
* format = csv
* filename = allcols/allcols.data
* field_sep = :
* columns = *
* pg_option_work_mem = 14MB
*
*/
LOAD CSV
FROM inline (a, b, c)
INTO postgresql:///pgloader?allcols (a, b, c text using (subseq c 0))
WITH fields optionally enclosed by '"',
fields escaped by double-quote,
fields terminated by ':'
SET client_encoding to 'latin1',
work_mem to '14MB',
standard_conforming_strings to 'on'
BEFORE LOAD DO
$$ drop table if exists allcols; $$,
$$ create table allcols (
a integer primary key,
b date,
c text
);
$$;
1:2008-02-18:first entry
2:2008-02-19:second one
3:2008-02-20:another
4:2008-02-21:still running
5:2008-02-22:well, some more
6:2008-02-23:antepenultima
7:2008-02-24:next to last
8:2008-02-25:hey, it's today!
|
