SQLite does not provide that capability, that I recall. But surely it would not be too difficult for you to do your own custom patch, or even to write a short program to output the data in the precise format you desire?
On 6/12/17, d...@dan.bz <d...@dan.bz> wrote: > Hi, > > When outputting to CSV with '.mode csv' is there a way that all rows can > be quoted even if there are no spaces? For example, here is a 1 line > from the output: > > spotify:track:5vlDIGBTQmlyfERBnJOnbJ,Kiso,Circles,100.019 > > I would like it to output: > > "spotify:track:5vlDIGBTQmlyfERBnJOnbJ","Kiso","Circles",100.019 > > Thanks! > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users