sqliteheaderconfig

How to configure sqlite to display headers by default

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.

Solution

  • From the fine manual:

    INIT FILE
    sqlite3 reads an initialization file to set the configuration of the interactive environment. [...] If the file ~/.sqliterc exists, 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