GitHub - simonw/db-to-sqlite: CLI tool for exporting tables or queries from any...
source link: https://github.com/simonw/db-to-sqlite
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
README.md
db-to-sqlite
CLI tool for exporting tables or queries from any SQL database to a SQLite file.
Usage: db-to-sqlite [OPTIONS] PATH
Load data from any database into SQLite.
https://github.com/simonw/db-to-sqlite
Options:
--version Show the version and exit.
--connection TEXT SQLAlchemy connection string [required]
--all Detect and copy all tables
--table TEXT Name of table to save the results (and copy)
--sql TEXT Optional SQL query to run
--pk TEXT Optional column to use as a primary key
--help Show this message and exit.
For example, to save the content of the blog_entry
table from a PostgreSQL database to a local file called blog.db
you could do this:
db-to-sqlite blog.db \
--connection="postgresql://localhost/myblog" \
--table=blog_entry
You can also save the data from all of your tables, effectively creating a SQLite copy of your entire database. Any foreign key relationships will be detected and added to the SQLite database. For example:
db-to-sqlite blog.db \
--connection="postgresql://localhost/myblog" \
--all
If you want to save the results of a custom SQL query, do this:
db-to-sqlite output.db \
--connection="postgresql://localhost/myblog" \
--table=query_results \
--sql="select id, title, created from blog_entry" \
--pk=id
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK