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