hpydktvjnksya kfoxwfswkhlhuk wrote: > 1. ".mode tabs" works strange: > > echo -e ".show\n.mode tabs\n.show" | sqlite3 | grep mode > mode: list > mode: list
That's how it works. > 2. "separator" changes to "\t", but cannot .import files with "\"": > > echo -ne "\"\t" >f && sqlite3 <<EOF > create table t(a text, b text); > .separator "\t" > .import f t > EOF > Error: f line 1: expected 2 columns of data but found 1 In its import files, sqlite3 always interprets " as quote character. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users