metalx1000

sqlite3 Dump tables to csv

Jun 15th, 2020
518
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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;"
RAW Paste Data