Skip to content

Instantly share code, notes, and snippets.

@tejainece

tejainece/sqlite2csv.sh

Forked from carlosefonseca/sqlite2csv.sh
Created March 19, 2018 13:15
Show Gist options
  • Save tejainece/6c96c9db4182596b867c91d057a61b92 to your computer and use it in GitHub Desktop.
Save tejainece/6c96c9db4182596b867c91d057a61b92 to your computer and use it in GitHub Desktop.
Download ZIP
Exports all tables in a sqlite database to CSV.
Raw
sqlite2csv.sh
#!/usr/bin/env bash
# obtains all data tables from database
TS=`sqlite3 $1 "SELECT tbl_name FROM sqlite_master WHERE type='table' and tbl_name not like 'sqlite_%';"`
# exports each table to csv
for T in $TS; do
sqlite3 $1 <<!
.headers on
.mode csv
.output $T.csv
select * from $T;
!
done
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment