Re: [sqlite] two questions about formatting output

2006-08-29 Thread John Salerno
I'll definitely move on to using Python to work with SQLite, so I guess this won't be a problem eventually, but for now the command line program is a very easy way to test out things and just use a database on the fly, without having to write the extra code involved in connecting to it via a separ

Re: [sqlite] two questions about formatting output

2006-08-29 Thread drh
"John Salerno" <[EMAIL PROTECTED]> wrote: > Just as a follow-up, I noticed that one of my columns *did* expand to > fit a longer name, yet another column didn't. Could it be because the > one that expanded contained a string of a single word, while the > column that didn't expand contained multiple

[sqlite] two questions about formatting output

2006-08-29 Thread John Salerno
Is it possible to change the width of columns in column mode in some general way? What I mean is, I know I can do .width X X X etc., but that requires knowing how many columns you have. Is there some way to set it so that the column will simply expand to fit the information? Second, I created a r