Thanks! Boxes aren't necessary, but it's nice to have the columns like that. I'll have to look into these options more.
John On 8/24/06, Martin Jenkins <[EMAIL PROTECTED]> wrote:
John Salerno wrote: > Hi everyone. Is it possible to format the output of a query > differently when using the command line program? I'm thinking along > the lines of MySQL, which puts rows and columns in boxes, and has the > column names at the top. It's very nice and easy to read. I find the > default format hard to read and too close together. To get column separators and headings (but not boxes) issue the following commands at the prompt. .mo co .he on The .w [20 30 40] command lets you change column widths - as many as you've specified - three in my example. I think you can put these commands into a .sqliterc file so that they're loaded when you start the command line client, but I've not tried that. Martin ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
