Re: [sqlite] .mode tabs does not work

2012-09-29 Thread Clemens Ladisch
hpydktvjnksya kfoxwfswkhlhuk wrote: > Clemens Ladisch wrote: >> In its import files, sqlite3 always interprets " as quote character. > > No, sqlite3 ".separator \t" does not interpret " before 3.7.11: > > 3.7.10 2012-01-16 13:28:40 ebd01a8deffb5024a5d7494eef800d2366d97204 > Lines in t: 1 > >

Re: [sqlite] .mode tabs does not work

2012-09-29 Thread hpydktvjnksya kfoxwfswkhlhuk
Clemens Ladisch wrote: >> 2. "separator" changes to "\t", but cannot .import files with "\"": >> >> echo -ne "\"\t" >f && sqlite3 <> 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

Re: [sqlite] How much disk space is required to checkpoint?

2012-09-29 Thread David Barrett
On Fri, Sep 28, 2012 at 10:49 AM, Jay A. Kreibich wrote: > The standard C I/O library includes the tmpfile() call, which performs > the whole process of generating a random temporary file name, opening > the file, and then unlinking the file. Wow, very interesting, thank