load csv
from all filenames matching ~<matching.*csv$>
in directory 'data'
having fields (id, field)
into postgres:///pgloader
target table matching
with fields optionally enclosed by '"',
fields terminated by ',',
truncate,
disable triggers,
drop indexes
-- workers = 8,
-- concurrency = 1
before load do
$$ drop table if exists matching; $$,
$$ create table matching(id int, field text); $$;