From: Ron <ronljohnsonjr@gmail.com> Sent: Friday, October 13, 2023 10:15 PM To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org> Subject: Re: Connecting 2 databases within the same instance
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 olderdblinkmodule. Butpostgres_fdwprovides 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 ?