I am having some problem with psycopg2 in python
I have two disparate connections with corresponding cursors:
1. Source connection - source_cursor
2. Destination connection - dest_cursor
Lets say there is a select query that I want to execute on source_cursor:
SELECT id, date
FROM source_table
WHERE id > 200
The result of this query should be inserted into a table at the dest_cursor
I have looked into copy_from and copy_to and examples such as this. They make use of external files to copy the data, instead I need to copy it directly without using files. Direct connection between the source and destination databases is not possible, otherwise I would have done it at the database side.
I think it is possible using fetchall()
and an INSERT
.. or some method which directly enables us to copy data.
Any help with links to similar examples greatly appreciated