Pgloader: Import from multiple CSV files

[mmuruev]

Can find if it is already present but I need have import from multiple CSV files by filename template.

[dimitri]

Can you use the FILENAMES MATCHING feature as described in the documentation?

[ ALL FILENAMES | [ FIRST ] FILENAME ]  
MATCHING regexp  
[ IN DIRECTORY '...' ] 

[eggie5]

@dimitri The documentation doesn't suggest the ALL FILENAMES MATCHING works for FIXED files. Also, I tried it and it complains about a syntax error. Should this work for FIXED too?

[dimitri]

A very quick glance at the parser code makes me believe it should work. Can you paste more details, such as your command and the error message?

[eggie5]

The order of the in directory was important and wasn't clear to me from the docs. I got this working:

LOAD FIXED  
  FROM all filenames matching ~<saltsnck_[drug|groc]>
     in directory '~/Development/DSE/DSE220/IRI_Data/Year1/External/saltsnck/'

Thanks.