On occasion I have had a need to import large amounts of data from standard input via a pipe. Here's an example of how to import from a pipe using sqlite3 on Ubuntu:
$ { grep -v '^#' <<eof # create the table create table foo (bar int) ; eof } | sqlite3 foo.sqlite $ seq 1 1000000 | sqlite3 foo.sqlite '.imp "/dev/stdin" "foo"' $ sqlite3 foo.sqlite 'select count(*) from foo; ' 1000000 Regards, - Robert _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users