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]
-----------------------------------------------------------------------------

Reply via email to