Copy RecordSet

How i can insert all the Data from One Table to in Other Database with the same Table name

you can combine Insert and Select commands.


Christian, I think he is speaking of tables in different databases, not tables.

Some options:

  • If you are using SQLite look at AttachDatabase.
  • Export to a file and import into the other database from that file.
  • Generate INSERT statement strings from db1 and apply them to db2.

i need to replicate or Clone Db1 with table1 to Db2 with table1 (i am using PostgreSQL)

dblink is a module which supports connections to other PostgreSQL databases from within a database session:
F.9. dblink