CREATE TABLE first_query ( AADFYear int, RoadCategory text,
LightGoodsVehicles text, PRIMARY KEY(AADFYear, RoadCategory);

COPY first_query (AADFYear, RoadCategory, LightGoodsVehicles) FROM '..ukTrafficAADF.csv' WITH DELIMITER=',' AND HEADER=TRUE;

Failed to import 5000 rows: ParseError - Invalid row length 29 should be 3,  given up without retries