If you’d like your SQLite terminal to show tables in the “prettier” format I demo’d in class yesterday, type this command before running your select * from tablename command:

sqlite> .mode table

If you like the way this displays, and want it to permanently be that way for you, create a file in your home directory called literally .sqliterc and put this line in it:

.mode table