Import CSV using Rfc4180CsvParser and exclude header row
Is there a way to exclude the header row when importing data via the Rfc4180CsvParser?
The COPY command has a SKIP opion but the option doesn't seem to work when using
copy scratch.test from '/home/root/data/test.csv' with parser Rfc4180CsvParser() SKIP 1 ;
Alternatively, the file is a C++ file is just 135 lines, so it should be feasible to modify it, and recompile using `make`.
Presumably we keep a counter, increment it for each lines encountered, and not write out some initial number of lines. But I don't quite see where to make that incision. Hints?