Export to CSV feature

[javidbu]

Issue Type

Feature Request

Description

It would be great if we could export to CSV a query result, with some settings like csv_delimiter, csv_header (true/false), csv_quote_character and things like that. This is super helpful for sharing the result with others, using it in another tool...

Version

• SQLTools Version: v0.9.9

[MxJ24]

use this plugin https://github.com/misfo/Shell-Turtlestein
and shell command
function tbl2csv() {
sed '/^[-+]-.*$/d;/^ *$/d;s/|/,/g;s/^,//g' $@
}

[amohield]

Having this built in is essential. If you're pulling data using SQL, you almost definitely are going to be manipulating in some way, be it in R, Python, Excel, or something else. So being able to export it to an easily readable, standard format is key.