Formatting output in SQLite

When doing a select statement in , the default formatting is hard to read. You can "pretty print" the out put using .headers on and .mode column like this:
.headers on
.mode column
SELECT * FROM table;
The .headers on and .mode column only need to be used once and the settings will stay that way for the whole session.

You might like