1--
2-- See https://github.com/dimitri/pgloader/issues/297
3--
4-- The "t" field would be "temperature", for instance.
5--
6
7LOAD CSV
8    FROM inline (a, b, nil, t)
9    INTO postgresql:///pgloader?temp(a,b,nil,t)
10
11    WITH fields terminated by ';'
12
13  BEFORE LOAD DO
14  $$ drop table if exists temp; $$,
15  $$ CREATE TABLE temp
16      (
17       a   integer,
18       b   timestamp without time zone,
19       nil real,
20       t   real
21      );
22  $$;
23
24
25100;2015-01-01 00:00:00;-6;10
26101;2015-01-02 00:00:00;-2.1;12.5
27102;2015-01-03 00:00:00;3.4;5.5
28103;2015-01-04 00:00:00;4.7;-2.3
29104;2015-01-05 00:00:00;0.4;0