display-results-in-readable-column-format.md

Display Results In Readable Column Format

By default the output of a query or pragma command will be pretty squished and unreadable.

sqlite> PRAGMA table_info(User);
0|id|TEXT|1||1
1|name|TEXT|0||0
2|email|TEXT|0||0
3|emailVerified|DATETIME|0||0
4|image|TEXT|0||0

However, this can be improved by setting the output mode to column.

sqlite> .mode column

With that set, we can run the same command which will now output nicely formatted columns with headers.

sqlite> PRAGMA table_info(User);
cid  name           type      notnull  dflt_value  pk
---  -------------  --------  -------  ----------  --
0    id             TEXT      1                    1
1    name           TEXT      0                    0
2    email          TEXT      0                    0
3    emailVerified  DATETIME  0                    0
4    image          TEXT      0                    0

For more details on this and the many other output modes, check out the docs.