search

simonw / db-to-sqlite

CLI tool for exporting tables or queries from any SQL database to a SQLite file
Apache License 2.0
370 stars 29 forks source link

Add option for selecting tables to copy by a (regex) pattern #40

Open sgraaf opened 2 years ago

sgraaf commented 2 years ago

Besides just --all to select all tables, --table to select specific table, or --sql to run a custom SQL query, it would be nice to be able to select table to copy via a regex pattern for table names. It could look something like this

db-to-sqlite "postgresql://localhost/myblog" blog.db \
    --table-name-pattern "tag_\w+"
manojlds commented 1 year ago

Good option to have!