Q: Run SQL Directly on CSV Files

Re:Q: Run SQL Directly on CSV Files by hyperbovine on Thursday November 15, 2018 @03:51AM (#18457831)

I can’t stand it when I’m banging out a CSV by hand and have to manually escape the field and record separators. Happens all the time.

[ Parent | on HN ]

Re:Q: Run SQL Directly on CSV Files by z92 on Thursday November 15, 2018 @09:47AM (#18459586)

I use TSV for that reason. Most of the time you don't need to escape anything. And from code you need to escape/unescape only 4 chars. \t \n \NULL and \\.

[ Parent | on HN ]