Mapd loading table into db


i have loaded a table in wrong db i have to load that same table into in another db
how to move a table from one db to another db
is there any query?


Hi @nagulan,

The SQL command line does not support referring to a table in another database using


construct. So you are left with the following options:

  1. Reimport the database from original source file.
  2. Programmatically (Java/Python) open a cursor to each database and read the buffer from source table and copy it to the destination table.

Bulk import with option 1 will be more performant.