i'm trying dump schema test.db
(i.e. no data) file called schema.sql
command line in os x without launching sqlite3.
i know can do:
sqlite3 .open test.db .output schema.sql .schema .quit
but don't want launch sqlite 3. this...
echo '.output schema.sql' | sqlite3 test.db
creates empty file this...
echo '.schema' | sqlite3 test.db
only prints schema. how can write file terminal?
thanks!
the shell allows redirection, , sqlite3
can command parameter:
sqlite3 test.db .schema > schema.sql
Comments
Post a Comment