Re: 'Sharing' data across different database.

From: "DINESH NAIR" <Dinesh_Nair(at)iitmpravartak(dot)net>
To: Edwin UY <edwin(dot)uy(at)gmail(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: 'Sharing' data across different database.
Date: 2025-06-23 19:02:19
Message-ID: PN2P287MB0512239A04CE8DF7E704E82C9C79A@PN2P287MB0512.INDP287.PROD.OUTLOOK.COM
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin


Hi,

FDW is the best secured option in Postgres to access data among other databases

https://www.postgresql.org/message-id/609c8cd402e145e2af12bcfe20ac22e1%40NetCracker.com

[https://www.postgresql.org/media-archives/img/about/press/elephant.png]<https://www.postgresql.org/message-id/609c8cd402e145e2af12bcfe20ac22e1%40NetCracker.com>
dblink Future support vs FDW<https://www.postgresql.org/message-id/609c8cd402e145e2af12bcfe20ac22e1%40NetCracker.com>
Hello, This is my attempt to seek support at PostGreSQL. So, if I have broken any protocols/rules or violated any …
www.postgresql.org
https://www.postgresql.org/message-id/609c8cd402e145e2af12bcfe20ac22e1%40NetCracker.com

[https://www.postgresql.org/media-archives/img/about/press/elephant.png]<https://www.postgresql.org/message-id/609c8cd402e145e2af12bcfe20ac22e1%40NetCracker.com>
dblink Future support vs FDW<https://www.postgresql.org/message-id/609c8cd402e145e2af12bcfe20ac22e1%40NetCracker.com>
Hello, This is my attempt to seek support at PostGreSQL. So, if I have broken any protocols/rules or violated any …
www.postgresql.org

[https://enterprisedb.com/themes/custom/edb_theme/logo-dark.png]<https://www.enterprisedb.com/postgres-tutorials/using-foreign-data-wrappers-access-remote-postgresql-and-oracle-databases?lang=en>
Using Foreign Data Wrappers to access remote PostgreSQL and Oracle databases<https://www.enterprisedb.com/postgres-tutorials/using-foreign-data-wrappers-access-remote-postgresql-and-oracle-databases?lang=en>
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(dot)uy(at)gmail(dot)com>
Sent: Monday, June 16, 2025 10:10 AM
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Motog Plus 2025-06-25 08:35:25 Guidance Needed: Scaling PostgreSQL for 12 TB Data Growth - New Feature Implementation
Previous Message Scott Ribe 2025-06-23 17:29:50 Re: update behavior