Обсуждение: 'Sharing' data across different database.
Hi,
Is using Foreign Data Wrapper the only available option to access data amongst databases?
Regards,
Edd
Foreign data wrapper or a dblink (https://www.postgresql.org/docs/current/contrib-dblink-function.html) are your options.
Best Regards,
Tim
On Sun, Jun 15, 2025 at 11:40 PM Edwin UY <edwin.uy@gmail.com> wrote:
Hi,Is using Foreign Data Wrapper the only available option to access data amongst databases?Regards,Edd
Hi,
FDW is the best secured option in Postgres to access data among other databases
Hello, This is my attempt to seek support at PostGreSQL. So, if I have broken any protocols/rules or violated any … www.postgresql.org |
Hello, This is my attempt to seek support at PostGreSQL. So, if I have broken any protocols/rules or violated any … www.postgresql.org |
This article explains how to use Foreign Data Wrappers to access data in remote PostgreSQL and Oracle databases. www.enterprisedb.com |
Thanks & Regards
Dinesh Nair
From: Edwin UY <edwin.uy@gmail.com>
Sent: Monday, June 16, 2025 10:10 AM
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: 'Sharing' data across different database.
Sent: Monday, June 16, 2025 10:10 AM
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: 'Sharing' data across different database.
Caution: This email was sent from an external source. Please verify the sender’s identity before clicking links or opening attachments.
Hi,
Is using Foreign Data Wrapper the only available option to access data amongst databases?
Regards,
Edd