SQLite – Table_info Looks Messy

command linesqlite

I created a new database by using the command line binary on Suse.
After activating headers by using .headers ON it still looks messy when getting table information with PRAGMA table_info(TABLE1);:

cid|name|type|notnull|dflt_value|pk
0|COLUMN1|REAL|1||0

How can I achieve a cleaner look like this:

sqlite> pragma table_info(member);
cid      name          type     notnull  dflt_value  pk     
-------  ------------  -------  -------  ----------  -------
0        account_id    text     1                    0      
1        account_name  text     1                    0      

Best Answer

In the sqlite3 command-line shell, this output format can be selected with .mode column.