Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uTmR5-009lgV-6u for pgsql-admin@arkaria.postgresql.org; Mon, 23 Jun 2025 19:02:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uTmR3-005ofC-9s for pgsql-admin@arkaria.postgresql.org; Mon, 23 Jun 2025 19:02:29 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uTmR2-005of4-HB for pgsql-admin@lists.postgresql.org; Mon, 23 Jun 2025 19:02:29 +0000 Received: from mail-southindiaazlp170110002.outbound.protection.outlook.com ([2a01:111:f403:c409::2] helo=MA0PR01CU012.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uTmR0-003b1i-2b for pgsql-admin@lists.postgresql.org; Mon, 23 Jun 2025 19:02:28 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=zD9xcIQlbM4fcl9Xki6R/nNSnz+H3MPFWpWaWUYB45YUuA0K5MGEZctc5KsAdrobOcMyOgfq7RQtU74lLrStadPysUpQfPO66CBSwrlvVEiF2UY8lOnf5XuVpVdSdZ8KxI9ZPaskx/NtnWMIh0uYR2I1jGBk2WZ0Mztp9NhQCcRBxvxLOm/1ZMzPWgnkud1uQXTFPLttZHPGQcHNY02K9RPTm68Z1l5i2f2zjxSXX1ztPKNpF5E9YhoqIgoEtxycbt6Z9+K0NVWw4RfLe8LCSszDdNQag3FA825ydoQ+LQTCmGOQ9zs/129ooagLwECzkVYBz2/ZTyd9xPlF2tU0dg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=+k+UfVPlOZ1q+gUNdkp6VcbM3ntutXH2TSsex1OI2M0=; b=af5JVgZ6RtsB6/3oZrK/bAcaI8RVIQWeDGLYwhTZhVtENUhhx6kXRQJt6NxXXLNEwbKD5rPlV1bIDuhpEz901t0fNcHEQ3tCBx9fciy1mthT+gT62z8YmLydsC3UaYdMzMGA08g5OOjuFBebEuslRzNg+ixdUknr8PhZUo75gSpEd0W8btPwg6sAHdPtlk2mFS3ZgRIIsBTI7JTnEPOi9TFBQ77UBIyoPKuKxMqqeu8Y85cndPEdK+C08WwkA6Dbp0Nbd9NbDtFvp9RKMBdWX/fhgzl7QwaHxsHOl1tskny0Kna/wxJzqgBQEtKuD0xI9WkrHOIgZCi6PQDfpLxW3g== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=iitmpravartak.net; dmarc=pass action=none header.from=iitmpravartak.net; dkim=pass header.d=iitmpravartak.net; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=iitmpravartak.net; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=+k+UfVPlOZ1q+gUNdkp6VcbM3ntutXH2TSsex1OI2M0=; b=G2yVcByndE0Oqr3pSQNf1OJ9sBJiiFUn/6zE02WE7HQQJgNYRjk9tFZ4kHz/mzcEitQ/BSZJFUN5E077cozjKGp0nirjDZbxvh5oI6EXZ5awmy0aABNieLWVNAx75+SYdvQGomwdtVM7dkXVp+JSR/kUsZ6siqHTyexK94s3Dj+gDuWtpzp+sRxhkzw7SIqh5VtTlrzFhyIS3SINS41Igv5+N1MTVb5gPOWLFUyLs1zx5fffy4p+nyse9/vEItMrlLbcy992e7JMtyTAZ9lW654rxksH2cYieyFBA6QndClkU7crrBHMsKDWvcZQbGqYK0WqKTzHnrV5fWo9Il53mA== Received: from PN2P287MB0512.INDP287.PROD.OUTLOOK.COM (2603:1096:c01:119::8) by MA0P287MB1420.INDP287.PROD.OUTLOOK.COM (2603:1096:a01:fa::14) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.8857.30; Mon, 23 Jun 2025 19:02:19 +0000 Received: from PN2P287MB0512.INDP287.PROD.OUTLOOK.COM ([fe80::e54f:e15:fbb:9f18]) by PN2P287MB0512.INDP287.PROD.OUTLOOK.COM ([fe80::e54f:e15:fbb:9f18%3]) with mapi id 15.20.8857.026; Mon, 23 Jun 2025 19:02:19 +0000 From: "DINESH NAIR" To: Edwin UY , Pgsql-admin Subject: Re: 'Sharing' data across different database. Thread-Topic: 'Sharing' data across different database. Thread-Index: AQHb3njhNrJsE/BOCkqq0kXLWA4HmbQRI047 Date: Mon, 23 Jun 2025 19:02:19 +0000 Message-ID: References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=iitmpravartak.net; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: PN2P287MB0512:EE_|MA0P287MB1420:EE_ x-ms-office365-filtering-correlation-id: 0da8736c-b260-4183-802b-08ddb2887a36 x-ms-exchange-atpmessageproperties: SA x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|376014|366016|1800799024|39142699007|31052699007|69100299015|13003099007|8096899003|7053199007|38070700018; x-microsoft-antispam-message-info: =?Windows-1252?Q?haLWwyyEo5xABW8OaPKyWnCz5KTpsIsteIyYY+PWd4OkgHsun9Atj3Q3?= =?Windows-1252?Q?HoAbxdEdu+JL6riTtnR54Ut+Zyr6OYjkLyd/DGFsWG1az/qKl1e/WdQ1?= =?Windows-1252?Q?EUt1i8yWrEAm/hntHQDI+mgd8PsrhY6j8cGTO5EfzUvp+NG/VfhIZAaP?= =?Windows-1252?Q?YJ0IOxZFkJCjX5VzI9nGDp1o7B3vTuuLwlKVnnj8jeXG3YmABEzDE3bg?= =?Windows-1252?Q?2qF5oBJcAa424uD68tv7QzKnmIx8tft0fJy2l9ojLuVFpH8+7608DnGv?= =?Windows-1252?Q?laaIDLZyBAtRfsl38cw/9GWZs1xnZiZNN2jKYQj0kW+WqaryndcWTJaR?= =?Windows-1252?Q?0B+86Nw5pb7t+LxEmQLZV35IaBQiv/alTyKBpfMa+NnLjW8OG6iwGqEi?= =?Windows-1252?Q?2mRl25IshyU7Iy62xurSEHuhM20aJ59ZiC3lU0UKXuzIrpUWGuTH7X42?= =?Windows-1252?Q?VJa91k/vEwz3KOLf9yxV6iHmal+3GUJOZYrwUvDDiTplIbJSXwtU/AH6?= =?Windows-1252?Q?VUq8nsUAszJwNQSDiciPXScQtkHaO2elVRREpTf1fXCu+GqKak2GvT7f?= =?Windows-1252?Q?N4FstU9UkY0nAGDlLl1QEhZAC7XOjcxgaX8n1y7uXZ57Dn6OZP6URIV2?= =?Windows-1252?Q?4sZHZLiSvc/iKSozECA1qRp89xmH0fdSpgcQ73UOLG31CNAShxULTOdW?= =?Windows-1252?Q?C0JoD0Lx0HhkqPh+HSm22bWuDVovsZYfP0epk8duT2S+rKe4zy53PATm?= =?Windows-1252?Q?xrOIdsnNlSKQv1S1uak7pP8t81EYjP+oX9TeenpkberpIPXsSgSN2RJT?= =?Windows-1252?Q?PnlODi0Z6axJVCwm7EZS64p3Kx63Jo/DfJARH046AVC9zjYLEnCkoD+1?= =?Windows-1252?Q?4QVfh/pWkz9IXp/XQurhEM82KJGup7N8aVlQF1xhsDg6StyxZ7/JWzNQ?= =?Windows-1252?Q?iYt9U+Dze8xHn6X9hPGZym/nRcxgLYjEvvWbWR1QZ6NJywcCwqgp+b18?= =?Windows-1252?Q?YuIw5qXXZfeb4/cXtHrwvDY3q3mj5+UU3hPCsp+1D0kahM50vxzxa8iQ?= =?Windows-1252?Q?j1HV1wDun2XPoqOrA+cCqvhTVRScE5jyUTGqBvCCgCLGsX6wLbbudLKV?= =?Windows-1252?Q?5fPIUhwCJa4cjHi7xXQp7o5wxcihG1tZO10lwoaFUnZgTQHESHF6dEok?= =?Windows-1252?Q?4h8zzrvqriERBpN/oSHTMK6DD2Isnjb0i0WnrwXC4FlHtllUmUmPDvQN?= =?Windows-1252?Q?Vz36tUOeK21IiVauYPAlZg8cHQNtSW/wZA5Tin3UD0no3GFbJ6JgJPfy?= =?Windows-1252?Q?s86YfHmZXdJ1lTPu9NasV7bh+w3wVn1ng99xumDZZtdXxfZ0kxnk6YjX?= =?Windows-1252?Q?Mm1dQFqV2E8WW2xF5mG7MUN5IPU4d+JxGXCGALg8V0E0tcA+90onS9YD?= =?Windows-1252?Q?RSiZsJ5tBKWMOHj9uAHjGw1hwPKRmVapHUk4tQ/CcPZ1XCw404TNqGii?= =?Windows-1252?Q?xnqt8l3Jkkn/8/B3Zf+QAL6ftP4QZwhUdGzROdcU+kTok7wAjYU=3D?= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:PN2P287MB0512.INDP287.PROD.OUTLOOK.COM;PTR:;CAT:NONE;SFS:(13230040)(376014)(366016)(1800799024)(39142699007)(31052699007)(69100299015)(13003099007)(8096899003)(7053199007)(38070700018);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?Windows-1252?Q?XHDm2Ohu+KoWY9dYoqMSz3YpFyfENj0MBHnMKl7V5VB/SMkOBOntC8CW?= =?Windows-1252?Q?euPA6wJXkipzfYuxaabMKqzIo7CaE/JkYqi/LEV1FmCBQHBf7sYsg/L3?= =?Windows-1252?Q?vFVryftb91rtWsFK/kO2oJtZznLRokfwiG1zzDgFhgVea298ZNSPoTJ8?= =?Windows-1252?Q?WkpKqvkg5A5WjLVo/QIRCz3tb7bc/VKMxvoDG2TINx2IgCwvL2m0gH2D?= =?Windows-1252?Q?yrZvFYHgI3X6I2GvevzKJca0ONdSs24V+7hDaa+Iq/25ZGUufyJueIpz?= =?Windows-1252?Q?5xIxlhTL/w+2xgGtiVmHvitpBSD4Xp6c7bUTtO64GC1lfpjPzPToG2MH?= =?Windows-1252?Q?JnzbJrwBdF4xnHL12W/+6Ay6NrUF4/Es9oLR/W5IW/m8TpTftvULXYOe?= =?Windows-1252?Q?eRjTBqt/86N+q9yNqJPfVPrSdAJh88xKixWolw6f1e+sucoHEIPqnp6a?= =?Windows-1252?Q?4g35Kwju/0reBsJ6kXfFla5m5uLCav6Q9N+6dBuSxyTHpoZbvsJ9nyW+?= =?Windows-1252?Q?McV85yb95Hzxi6oWBxCxEgDFoHsI0fHjfqFoQOFt1i1Ppxn1cDS/asg/?= =?Windows-1252?Q?sUCOEo3zhAou/BAFpIKGK69ZCB7EtipYzoLqoYCnQtF/EyEkyrgYqLMd?= =?Windows-1252?Q?TUryIFycIez1ArNGlfiWGhQpJoHlyJLcFCrfZuo9UMIGceAvdB6E7Dtd?= =?Windows-1252?Q?6RsTPAMJuganzdvhgwm7kromkjuPuqVTegrxSlFq8hdd+AygKnOsjJKb?= =?Windows-1252?Q?BjJJu7dxxG/iOKh0Fpp9vpQZ246M/oTp+MlLSkTdz0foaFBvEDufIDQ1?= =?Windows-1252?Q?342WD4G3gv9evpPsxzSOkn5HFG/NsQZayEVlyidXOVCYgQaOSHaRvTsv?= =?Windows-1252?Q?M3cyfK3A+WUhXmjIMfMFzg3iCK8W2g6AWWQNj9DOVSsITvCPMDy+D2iw?= =?Windows-1252?Q?ZsyZ/m1y/BEggbqoQsZu52zbuVDSGl04orNtApvhT1qUTGP2dlL6Y6VH?= =?Windows-1252?Q?9pPudxCSwWj4Zbm+aKXfk7RBXMKSHsP4jfkZJpzMXh4mgzvOqNb5QZwX?= =?Windows-1252?Q?1xdVocisVnIiKhsbi+67OloXtFnjujE1Vflcif7WUFn2+xLR6kYQ66M9?= =?Windows-1252?Q?N1nEXo8HsV/2WbInNQWMeZXSGCS06ac0NrmGzEvoXF930I6pCjL9M8ty?= =?Windows-1252?Q?PJ8bubdLxhs3ZeXYtd4GPqq+NrdgPsXR5xV5AQ+qk+NdigAE3B3s+q9P?= =?Windows-1252?Q?eFBkNZ3HtGCFZhH/KtmCK0P4P+KqrmTbVpBcMFywparVY4iZ7g0hxwsb?= =?Windows-1252?Q?WN/y4/NHACTlS7lWFY33Rex9LddwrThef8X1Hx1F2KQuw0aaa5meBZu+?= =?Windows-1252?Q?fzBpZL8XMkPjJp8n9wApXevBXiNcHQ5HYKyekmSivH0UPHlawU9cZopa?= =?Windows-1252?Q?GsCAzdPsyZYb/BinUgXg8xBB3FKIWw7CTrmb0ThAgrct3Ox5kvIGVM8x?= =?Windows-1252?Q?PZ9xrU0H2KtSze+2971HCq7zCj1bIUAP/vcMweUjhyhDBqDJXkh2vbtz?= =?Windows-1252?Q?raUSK9AmQuSTRHHKElPWqTrQQtO27YWRn9sMS5qmqqgOe3DgxBg8BakR?= =?Windows-1252?Q?qc8EWoHK2yM+Sl4Zcf8gYlFdT5yQ0bDdmTRnn8FOEAHCs0lr//vp+3/w?= =?Windows-1252?Q?BSZvqhmTD6pCsB1gXHNeLUIl+/F+QZDxADujmgw2l1Zoha1gwPCP7w?= =?Windows-1252?Q?=3D=3D?= Content-Type: multipart/alternative; boundary="_000_PN2P287MB0512239A04CE8DF7E704E82C9C79APN2P287MB0512INDP_" MIME-Version: 1.0 X-OriginatorOrg: iitmpravartak.net X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: PN2P287MB0512.INDP287.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-Network-Message-Id: 0da8736c-b260-4183-802b-08ddb2887a36 X-MS-Exchange-CrossTenant-originalarrivaltime: 23 Jun 2025 19:02:19.1809 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 3e964837-c238-4683-9155-49f4ec04f8e9 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: HHpETMTxxCh7Mt7z3Q4Z1samJMvGnBMqsAPquudV8yOLDFSw831/6BBDjFjR+DBb4vVJVC86nttwXt2lPtpPjhjZYZKMaVaHUdxap5uNNnk= X-MS-Exchange-Transport-CrossTenantHeadersStamped: MA0P287MB1420 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_PN2P287MB0512239A04CE8DF7E704E82C9C79APN2P287MB0512INDP_ Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Hi, FDW is the best secured option in Postgres to access data among other dat= abases https://www.postgresql.org/message-id/609c8cd402e145e2af12bcfe20ac22e1%40Ne= tCracker.com [https://www.postgresql.org/media-archives/img/about/press/elephant.png] dblink Future support vs FDW Hello, This is my attempt to seek support at PostGreSQL. So, if I have brok= en any protocols/rules or violated any =85 www.postgresql.org https://www.postgresql.org/message-id/609c8cd402e145e2af12bcfe20ac22e1%40Ne= tCracker.com [https://www.postgresql.org/media-archives/img/about/press/elephant.png] dblink Future support vs FDW Hello, This is my attempt to seek support at PostGreSQL. So, if I have brok= en any protocols/rules or violated any =85 www.postgresql.org [https://enterprisedb.com/themes/custom/edb_theme/logo-dark.png] Using Foreign Data Wrappers to access remote PostgreSQL and Oracle database= s This article explains how to use Foreign Data Wrappers to access data in re= mote PostgreSQL and Oracle databases. www.enterprisedb.com Thanks & Regards Dinesh Nair ________________________________ From: Edwin UY Sent: Monday, June 16, 2025 10:10 AM To: Pgsql-admin Subject: 'Sharing' data across different database. Caution: This email was sent from an external source. Please verify the sen= der=92s identity before clicking links or opening attachments. Hi, Is using Foreign Data Wrapper the only available option to access data amon= gst databases? Regards, Edd --_000_PN2P287MB0512239A04CE8DF7E704E82C9C79APN2P287MB0512INDP_ Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable

Hi, 

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

https://www.postgresql.org/message-id/609c8cd402e145e2af= 12bcfe20ac22e1%40NetCracker.com


3D""
Hello, This is my attempt to seek support at PostGreSQL. So, if I have brok= en any protocols/rules or violated any =85
www.postgresql.org
https://www.postgresql.org/message-id/609c8cd402e145e2af= 12bcfe20ac22e1%40NetCracker.com

3D""
Hello, This is my attempt to seek support at PostGreSQL. So, if I have brok= en any protocols/rules or violated any =85
www.postgresql.org


3D""
This article explains how to use Foreign Data Wrappers to access data in re= mote 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.
 
Caution: This email was sent from = an external source. Please verify the sender=92s identity before clicking l= inks or opening attachments.
Hi,

Is using Foreign Data Wrapper th= e only available option to access data amongst databases?


Regards,
Edd
--_000_PN2P287MB0512239A04CE8DF7E704E82C9C79APN2P287MB0512INDP_--