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