Re: Connecting 2 databases within the same instance

Google is your friend.  Searching for "postgresql dblink" and "postgresql
fdw" take you right to the documentation:
https://www.postgresql.org/docs/15/dblink.html
https://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 olderdblink
<https://www.postgresql.org/docs/current/dblink.html>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
>
>
>
>
> Sent from my Galaxy
>
>
>
> -------- Original message --------
> From: swastik Gurung <gurung_swastik(at)yahoo(dot)com>
> Date: 10/13/23 9:37 PM (GMT-05:00)
> To: pgsql-admin(at)postgresql(dot)org, M Sarwar <sarwarmd02(at)outlook(dot)com>
> Subject: Re: Connecting 2 databases within the same instance
>
> 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(at)outlook(dot)com> 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
>

--
Born in Arizona, moved to Babylonia.