Search notes:

SQLite shell: tabular output

With the dot commands .mode column and the column width specifier .width …, it is possible to format a result in tabular form: 
sqlite3> .mode column
sqlite3> .width 10 25 54 …
sqlite3> select foo, bar, baz, … from tData;

See also

SQLite shell

Index