lukasmartinelli / pgfutter

Import CSV and JSON into PostgreSQL the easy way
MIT License
1.33k stars 128 forks source link

-d <delimiter> does not work with tab #37

Open dirkpetersen opened 7 years ago

dirkpetersen commented 7 years ago

using a custom delimiter I am getting this:

pgfutter --dbname tester --host mydb --port 32063 --username tester csv -d "\t" ~/sc/data/jobs.csv Please specify the correct delimiter with -d. Header column contains a delimiter character: job_db_inx account cpus_req exit_code job_name id_job id_user nodelist priority state partition timelimit time_submit time_eligible time_start time_end time_suspended

kiru commented 7 years ago

I think this problem already explained in the documentation:

If you want to use tab as delimiter you need to pass $'\t' as delimiter to ensure your shell does not swallow the correct delimiter. pgfutter csv -d $'\t' traffic_violations.csv

tkchan007 commented 7 years ago

doesn't work even with the -d $'\t'. on Windows 10 Pro. Thanks.