Menu
Is there any way to configure sqlite3 so that the headers will display by default?
I know I can use .headers on to turn on headers, but I have to keep typing it every time I launch the client because the setting doesn't stick between sessions. I want the headers to be on permanently.
283
Pretty simple really. Therefore, to enable column headers, simply use . headers on . As mentioned, you can disable column headers using .
To display the structure of a table, you use the . schema TABLE command. The TABLE argument could be a pattern.
The sqlite3 program is able to show the results of a query in eight different formats: "csv", "column", "html", "insert", "line", "list", "tabs", and "tcl". You can use the ". mode" dot command to switch between these output formats. The default output mode is "list".
From the fine manual:
INIT FILE
sqlite3 reads an initialization file to set the configuration of the interactive environment. [...] If the file~/.sqlitercexists, it is processed first. can be found in the user's home directory, it is read and processed. It should generally only contain meta-commands.
So just put a file called .sqliterc in your home directory and put this in it:
.headers ON You can pass arguments in the command line too:
sqlite3 db.db -header -column "select x from y;" If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
