On Thu, Oct 10, 2013 at 4:18 PM, Clemens Ladisch <clem...@ladisch.de> wrote:

> If you cannot generate newline characters, try to execute something
> like this:
>
>   (echo .separator "||"; echo .import path tbl) | sqlite3 dbfile
>

Alternately, most Unix shells allow:

echo -e ".separator '[||'\n.import ..."

the -e enables the conventional set of backslash escapes.

[stephan@host:~]$ echo -e ".separator ||\n.import foo bar"
.separator ||
.import foo bar

-- 
----- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to