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