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