Last Updated: February 25, 2016
·
324
· macodev

Sqlite3 - better table display in terminal

In order to display better tables on sqlite3, create the file .sqliterc in your home directory and add these two config params:

.headers on
.mode column

Next time you enter the cli, the tables will be shown better.