Google is your friend. Searching for "postgresql dblink" and "postgresql fdw" take you right to the documentation:
https://www.postgresql.org/docs/15/dblink.htmlhttps://www.postgresql.org/docs/current/postgres-fdw.html DB Link is much older, while FDW has better syntax and is usually faster:
"
The functionality provided by this module overlaps substantially with the functionality of the older dblink module. But postgres_fdw
provides more transparent and standards-compliant syntax for accessing remote tables, and can give better performance in many cases. "
On 10/13/23 20:40, M Sarwar wrote:
Hi,
Are you saying that Db Link is existing in the Postgress or just referring to FDW ?
Sarwar
-------- Original message --------
Date: 10/13/23 9:37 PM (GMT-05:00)
Subject: Re: Connecting 2 databases within the same instance
I think any of the two contrib module dblink and/or postgres_fdw could help
#yiv3643911366 p {margin-top:0; margin-bottom:0}
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
--
Born in Arizona, moved to Babylonia.