Re: Connecting 2 databases within the same instance

Hello Scott,
You have a solid point. I am coming onto Postgress environments for the last one year.
Thank you so much,
Sarwar

________________________________
From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
Sent: Friday, October 13, 2023 10:08 PM
To: M Sarwar <sarwarmd02(at)outlook(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Connecting 2 databases within the same instance

dblink is an older way to access external databases, in general I'd prefer FDW

--
Scott Ribe
scott_ribe(at)elevated-dev(dot)com
https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.linkedin.com%2Fin%2Fscottribe%2F&data=05%7C01%7C%7C48c15f64f1b34b39d37508dbcc5a7ba6%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638328461215945939%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=4lfbwFS8j6LznWFYX1G9PtR%2BHdXeb6KvqDph1JWxdaw%3D&reserved=0<https://www.linkedin.com/in/scottribe/>

> On Oct 13, 2023, at 7:40 PM, M Sarwar <sarwarmd02(at)outlook(dot)com> wrote:
>
> Are you saying that Db Link is existing in the Postgress or just referring to FDW ?
>