How to configure sqlite to display headers by default

sqlite header config
spemmo picture spemmo · May 7, 2011 · Viewed 24.1k times · Source

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.

Answer

mu is too short picture mu is too short · May 8, 2011

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

Related questions

Select first row in each GROUP BY group?

As the title suggests, I'd like to select the first row of each set of rows grouped with a GROUP BY. Specifically, if I've got a purchases table that looks like this: SELECT * FROM purchases; My Output: id | customer | total …

Read More
How to list the tables in a SQLite database file that was opened with ATTACH?

What SQL can be used to list the tables, and the rows within those tables in an SQLite database file - once I have attached it with the ATTACH command on the SQLite 3 command line tool?

Read More
How to get a list of column names on Sqlite3 database?

I want to migrate my iPhone app to a new database version. Since I don't have some version saved, I need to check if certain column names exist. This Stackoverflow entry suggests doing the select SELECT sql FROM sqlite_master …

Read More