User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.90 Safari/537.36
It would be really useful if MonetDB could have the ability to export a CSV file with column headers in the first line, as this kind of export/import operations is one of the most basic type of operations in data analysis.
Steps to Reproduce:
USING DELIMITERS '|', '\n', '"' NULL AS '' HEADER;
None, as HEADER is not implemented
A delimited file with column headers that could be imported in some statistical application for data analysis
There is something like this if you use mclient to export the data.
mclient -fcsv+, -d$database -s'select * from mytable' > myfile.csv
See the mclient manual .
I forgot to mention, you can use --null= to get the equivalent of NULL AS ''.