On 10-Jan-2008, at 1:45 PM, Samuel Gilbert wrote:
I though that typing ".mode csv" in your SQLite shell would solve
the problem.
I though it might be a good idea to test it before suggesting a
solution.
However, it only works with the results of queries and not with the
built-in
commands.
Well, .databases really just does the column setup and runs a fairly
simple query. I can just run that query myself (PRAGMA database_list;)
However, I didn't realize that until I read the code to shell.c.
So, anyway, when I ran .databases myself and saw the problem, the very
first thing I thought was "I'd better increase the column width!"
.width 5 5 100
Of course, that didn't help at all, because the width is hard-coded to
58. As someone who didn't know "PRAGMA database_list;", my choice at
this point was to read the source or go find the documentation. That's
fine, but it'd be better if this documented itself somehow (maybe by
repeating the internal query before executing it) or responded to my
workaround (which I imagine is one of the first thoughts of many who
hit this problem).
(As an aside, maybe the auto-formatting isn't right in this case. How
many databases do most have open? .mode line might be better here.)
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------