1LOAD COPY
2     FROM copy://./data/track.copy
3          (
4            trackid, track, album, media, genre, composer,
5            milliseconds, bytes, unitprice
6          )
7     INTO postgresql:///pgloader
8     TARGET TABLE track_full
9
10     WITH truncate, drop indexes
11
12      SET client_encoding to 'latin1',
13          work_mem to '14MB',
14          standard_conforming_strings to 'on'
15
16   BEFORE LOAD DO
17     $$ drop table if exists track_full; $$,
18     $$ create table track_full (
19          trackid      bigserial primary key,
20          track        text,
21          album        text,
22          media        text,
23          genre        text,
24          composer     text,
25          milliseconds bigint,
26          bytes        bigint,
27          unitprice    numeric
28        );
29     $$;
30