SQLite Forum

.DUMP feature request
Login
Can you please add an option to only dump the data part without the schema?

This will be complete in that

`.schema` gives just the schema

`.dump` gives everything

`.dump --data` gives just the data  (`.data` is already taken for `.databases`)

The only work-around I know of is `.mode insert table_name` followed by a corresponding `select` but it's tedious as each table needs to be done separately.