How do I use the sqlite cli tool?

Task	psql	sqlite3
List all tables	`\dt`	`.tables`
Show table schema	`\d tablename`	`.schema tablename`
Show all schema objects (tables, views)	`\d`	`.schema`
Describe database (metadata)	`\l`	`.databases`
Connect to database	`\c mydb`	`sqlite3 mydb.sqlite`
Quit the shell	`\q`	`.exit` or `Ctrl+D`
Execute a SQL file	`\i file.sql`	`.read file.sql`
List current database	`\conninfo`	Not applicable (only 1 DB in SQLite)
Set column display format	`\x`	`.mode column`
Toggle headers	N/A	`.headers ON` or `.headers OFF`
Export query to CSV	`\copy ... TO 'file.csv' CSV`	`.mode csv` + `.output file.csv` + SQL
Show table creation SQL	`SELECT * FROM pg_dump...`	`SELECT sql FROM sqlite_master WHERE type='table' AND name='mytable';`
List indexes	`\di`	`SELECT name FROM sqlite_master WHERE type='index';`
Show index definition	`\di+`	`SELECT sql FROM sqlite_master WHERE type='index' AND name='index_name';`
#sqlite #postgres