SQLite Forum

import mishandles table name
Login
The CLI .import command can only create tables in the main schema.  The tablename specifier in the command cannot be qualified with a schema name, the entire thing is taken as the table name -- including embedded dots.

If the specified tablename already exists in an attached schema, then the data will be imported into that table.  The ordinary search order for the tablename is used.  If the tablename is not found a new table is created in the main schema.

It is not possible to .import into a new table in any schema other than main using the CLI .import command.