02241130创建于 2021年6月9日历史提交
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
       );
    $$;