metalx1000

sqlite3 Dump tables to csv

Jun 15th, 2020
965
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 0.16 KB | None | 0 0
  1. ###List all tables and dump to csv
  2. table="$(sqlite3 owncloud.db ".tables"|tr " " "\n"|sort -u |fzf)"
  3. sqlite3 -header -csv owncloud.db "select * from $table;"
Add Comment
Please, Sign In to add comment