Re: [sqlite] formatting the output on the command line?

Thanks, I'll give this a try! John On 8/25/06, Martin Jenkins <[EMAIL PROTECTED]> wrote: John Salerno wrote: > Well, I figured out the sqlite commands, but how would I make these > settings the default each time I use the sqlite command line program? > (i.e. .he on and .mo col) If you're on Li

Re: [sqlite] formatting the output on the command line?

John Salerno wrote: Well, I figured out the sqlite commands, but how would I make these settings the default each time I use the sqlite command line program? (i.e. .he on and .mo col) If you're on Linux etc, put the commands in a file called .sqliterc in your home directory. If you're on Win

Re: [sqlite] formatting the output on the command line?

Well, I figured out the sqlite commands, but how would I make these settings the default each time I use the sqlite command line program? (i.e. .he on and .mo col) John On 8/25/06, Jay Sprenkle <[EMAIL PROTECTED]> wrote: There are a load of nice text processing programs for this sort of thin

Re: [sqlite] formatting the output on the command line?

There are a load of nice text processing programs for this sort of thing in Unix/Linux/BSD. Take a look at sed, ed, awk, or shell scripting. Any of them should do it without much effort. -- SqliteImporter and SqliteReplicator: Command line utilities for Sqlite http://www.reddawn.net/~jsprenkl/Sql

Re: [sqlite] formatting the output on the command line?

Thanks guys! On 8/24/06, Gary Kruck <[EMAIL PROTECTED]> wrote: There is a tutorial Here . Gary Martin Jenkins wrote: > John Salerno wrote: >> Is there any special command I need to use to get these options >> listed? I didn't see the particular abbreviations

Re: [sqlite] formatting the output on the command line?

There is a tutorial Here . Gary Martin Jenkins wrote: > John Salerno wrote: >> Is there any special command I need to use to get these options >> listed? I didn't see the particular abbreviations that you told me >> about. > > You can abbreviate the commands -

Re: [sqlite] formatting the output on the command line?

John Salerno wrote: Is there any special command I need to use to get these options listed? I didn't see the particular abbreviations that you told me about. You can abbreviate the commands - enter enough to be unambiguous. SQLite version 3.3.6 Enter ".help" for instructions sqlite> .h .databa

Re: [sqlite] formatting the output on the command line?

Is there any special command I need to use to get these options listed? I didn't see the particular abbreviations that you told me about. John On 8/24/06, Martin Jenkins <[EMAIL PROTECTED]> wrote: John Salerno wrote: > Thanks! Boxes aren't necessary, but it's nice to have the columns like > tha

Re: [sqlite] formatting the output on the command line?

John Salerno wrote: Thanks! Boxes aren't necessary, but it's nice to have the columns like that. I'll have to look into these options more. .h is your friend. You can set the output format to HTML etc Martin [off for a pint]

Re: [sqlite] formatting the output on the command line?

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 comma

Re: [sqlite] formatting the output on the command line?

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 fo

[sqlite] formatting the output on the command line?

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