postgresql - Reuse persistent dblink connection -


We have a function that is often triggered and makes remote DB a query. If I am not wrong then the connection work is in the current call / session. Is it possible to make a global connection in a remote DB and reuse this connection on each connection call?

The person we are facing takes a query more than 1 to transfer only 3 records.

say:

until the connection has closed or continues The database session has expired.

Then this function is designed to be reused in calls. Just reuse it.

Comments