I think any of the two contrib module dblink and/or postgres_fdw could help
On Saturday, 14 October 2023 at 03:38:33 GMT+5:45, M Sarwar <sarwarmd02@xxxxxxxxxxx> wrote:
Hello,
I have one instance and two database within it. What is the simplest approach which I can adopt to connect these 2 database to one another.
I want to have the ability to connect to any table. For example database link in Oracle databases. How can I deploy this gracefully?
Thanks,
Sarwar