Feature request: sqlite3 .output compatibility
t3h2mas opened this issue · 1 comments
t3h2mas commented
It would be great to be able to save query results using litecli. Currently, my workflow involves copying a query from litecli and using sqlite3 to get a csv.
Similar to the following in sqlite3
.mode csv
.output results.csv
...
amjith commented
There is a tee command available that will write the query and the results to a specified file. Here's an equivalent workflow.
.mode csv
tee filename.csv
Unfortunately this won't save just the output it will also include the query itself.
You can turn off the output to file using notee command.