[フレーム]
Last Updated: February 25, 2016
·
578
· potomak

Sqlite3 readable output

To make the sqlite3 console output more readable run:

$ (echo ".header ON" && echo ".mode column") > ~/.sqliterc

This will create a file named .sqliterc on your home directory with a minimal configuration enabling table headers and setting output mode to column.

Before:

sqlite> SELECT users.first_name, users.last_name FROM users;
John|Doe
Giovanni|Cappellotto

After:

sqlite> SELECT users.first_name, users.last_name FROM users;
first_name last_name 
---------- ----------
John Doe 
Giovanni Cappellott

AltStyle によって変換されたページ (->オリジナル) /