LOAD CSV
FROM data/track.csv
INTO postgresql:///pgloader
TARGET TABLE csv.track
WITH truncate
BEFORE LOAD DO
$$ drop table if exists csv.track; $$,
$$ create table csv.track (
trackid bigserial primary key,
track text,
album text,
media text,
genre text,
composer text,
milliseconds bigint,
bytes bigint,
unitprice numeric
);
$$;