[root@localhost mysite]# sqlite3 db.sqlite3 
SQLite version 3.7.17 2013-05-20 00:56:22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"

sqlite> .tables
auth_group                  django_session            
auth_group_permissions      django_site               
auth_permission             my_post                   
auth_user                   photo_album               
auth_user_groups            photo_photo               
auth_user_user_permissions  photo_publication         
bookmark_bookmark           photo_publication_albums  
django_admin_log            tagging_tag               
django_content_type         tagging_taggeditem        
django_migrations         

sqlite> .help

sqlite> .show
     echo: off
  explain: off
  headers: off
     mode: list
nullvalue: ""
   output: stdout
separator: "|"
    stats: off
    width: 

sqlite> .header ON

sqlite> .mode column

sqlite> select * from photo_publication;
id          title            
----------  -----------------
1           The Photo Journal
3           Science News     
4           Science Weekly   

sqlite> .exit

[root@localhost mysite]#