Efficient way to load bulk data from Oracle to PostgreSQL

I am looking for a better way in performance to handle bulk data from remote Oracle into PostgreSQL in local ( 50,000 rows ).
(Windows application).
Currently, just using PreparedStatement and insert the data in a loop with a RecordSet.

Dim ps As PostgreSQLPreparedStatement

Thinking of generating a file and load it into PostgreSQL by psql command.

I am wondering if there is any other nice method to improve this logic.
Memory processing or by Dictionary?

Don’t know if you want to do it in Xojo, if you can use an external utility check for Ora2Pg http://ora2pg.darold.net/index.html

These links might help you.