On Thu, 10 Oct 2013 16:27:21 +0200
Stephan Beal <sgb...@googlemail.com> wrote:
> > (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.
We're OT here, but I'm not so sure "most" shells support "echo -e".
Standard, simpler, and easier to remember is printf:
$ printf '.separator "||"\n.import path tbl\n' | sqlite3 dbfile
or just
$ echo '.import path tbl' | sqlite3 -separator '||' dbfile
--jkl
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
