On 12/6/15, Thomas Morris <morristc at me.com> wrote: > I recently took over a Java based application that has SQLite embedded and > now I need to export the database into a CSV format. Reading online, I have > found that using (dot)mode csv, or any (dot) command is not possible when > SQLite is embedded, simply due to the (dot) commands being for use within > the shell. Is there an alternative way to export, other than by using (dot) > mode, or am I simply out of luck? >
Do you need your Java application to do this export? Or do you just need to get this export done, once? If the latter, then simply move the database file to a workstation and run the (dot)commands there using a shell. -- D. Richard Hipp drh at sqlite.org