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.
I work on X11/Linux, and widening the terminal window doesn't convince SQLite to display more text. For example, this is what I get even when Konsole is 192 characters wide : sqlite> .databases seq name file --- --------------- ---------------------------------------------------------- 0 main /data/aq_modeles/afsuair/ocm/gridpt/dbase/prog/aqhi/basedo 2 obs /data/aq_modeles/afsuair/ocm/gridpt/dbase/prog/aqhi/basedo Therefore, does SQLite Guru, know how to get around this? Samuel On 2008-01-10 15:14, Steven Fisher wrote: > Just now I opened a bunch of shells, pasted the same query into all of > them, and closed the ones I didn't want after seeing the result. > > So I ran .databases to see which databases I'm actually left with, and > saw something like this (not exact): > > seq name file > --- ------ ---------------------------------------------------------- > 0 main C:\Documents and Settings\sfisher\Local Settings\Applicati > 1 temp C:\DOCUME~1\sfisher\LOCALS~1\Temp\blahblahblah (also too > long) > > Of course, all the databases I opened are in the same directory, so > this is really unhelpful in identifying which one I still have > open. :) Could the code for .databases be changed to not change the > column width to 58 if the width is already set to a larger value? > > --------------------------------------------------------------------------- >-- To unsubscribe, send email to [EMAIL PROTECTED] > --------------------------------------------------------------------------- >-- ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
