i’m using docker to host two different postgresql instances to try and produce a proof of concept for python as an etl to move data between the two i can connect to the one via python fine but then when calling a procedure inside the first instance it cant find the table in the second instance im connecting to the
Tag: dblink
How to SELECT all JOBS that using a DBLINK on oracle?
Is my pleasure to say helo to all of you. I need help on oracle to select all JOBS that using a DBLINK on oracle, to stop them during maintenance. I will appreciate your help.
iBATIS and dblink?
I am using PostgreSQL, and I use the dblink feature to update data on remote database. My project using iBATIS to work with database. I need to run the query statement with parameter but the problem is the db_link require SQL to be enclosed in quote. And iBATIS do not understand it.. I have iBATIS sql: But due to sql
Postgres Error: More than one row returned by a subquery used as an expression
I have two separate databases. I am trying to update a column in one database to the values of a column from the other database: UPDATE customer SET customer_id= (SELECT t1 FROM dblink(‘port=5432, …