You could also do it in sql, something like this

Set copycommit 10;
copy from user/password@database to user/password@database insert table1 using select * from table2

I am pretty sure that the "copy from ...." command as to be all on the same line.

This way is easier and takes a lot less resource.