[sqlite] Re: Re: Copy tables from one memory database to another with no disk access?

[Igor Tandetnik]

Jay Sprenkle wrote:
For that to work, one first needs to attach one database to the
other. ATTACH command requires a file name. Memory database does not
have one.

It's not ":memory:"?

Which one?

Every time you open a :memory: database you get a separate instance, 
identified only by its sqlite3* handle. I'm not sure if ATTACH would 
work with :memory:, but even if it does it would just create a new, 
empty in-memory database, not refer to the one (of possibly many) you 
already have open and populated.

Igor Tandetnik