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 <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1uR1sn-004vMz-Pr
	for pgsql-admin@arkaria.postgresql.org; Mon, 16 Jun 2025 04:55:45 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1uR1sk-00FLbB-NX
	for pgsql-admin@arkaria.postgresql.org; Mon, 16 Jun 2025 04:55:43 +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 <tggerber@gmail.com>)
	id 1uR1sk-00FLar-A0
	for pgsql-admin@lists.postgresql.org; Mon, 16 Jun 2025 04:55:42 +0000
Received: from mail-lf1-x136.google.com ([2a00:1450:4864:20::136])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.96)
	(envelope-from <tggerber@gmail.com>)
	id 1uR1sj-002EoJ-0X
	for pgsql-admin@lists.postgresql.org;
	Mon, 16 Jun 2025 04:55:41 +0000
Received: by mail-lf1-x136.google.com with SMTP id
 2adb3069b0e04-5532a30ac45so3862586e87.0
        for <pgsql-admin@lists.postgresql.org>;
 Sun, 15 Jun 2025 21:55:40 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1750049739; x=1750654539;
 darn=lists.postgresql.org;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:from:to:cc:subject:date:message-id:reply-to;
        bh=F9KVpM5cUiLjBsIbx16iucItHN/AvsHd2C8O8ibCQLo=;
        b=JV22AiX1hlkusAuPXQxMC7Iy/qOAMEcTKc/r8yFikPahXm9Ax/f2vkCh6epBH4DVtB
         trJGjcvl9x5eZmkeP2f0w4kQElPQkfWTTa/uQfkwrRgcjHGCfy8+0q/kyfzKeY+g0AZD
         lk+e4N2uIIqMJoW4w4QRDixqRa69gPstLBu5z1D5ByCL0fkcxGK/isIH/Slysc9CirPd
         kE/J0rurVeSrseodCZRNAY4HlC2EF04JNqD3/MX8n1+zp2mChmwBeX2RfjiKPb3EnALo
         Mtq1GOXpz3i2nXy+Au56salHW5fqrdcS6RmA/IsEESPbZK0KxKVbtN6LHUnhAbAP67UY
         JFyw==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1750049739; x=1750654539;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id
         :reply-to;
        bh=F9KVpM5cUiLjBsIbx16iucItHN/AvsHd2C8O8ibCQLo=;
        b=qddIhzhj7EgQBwWWm0GiKjr/+z99803HAg09LTFL5x2wBG3RJu9QY9ZNID9d/EvaFz
         H1/M33i+l+QgIkEwSS7fyxGCCjMkPb3rMR4Z3vvchaQmb74d4jrchsI2Lp7/jAel0uvk
         B9Fq0djTc4j7JBYcBznwSKfa2n+etckiRX8BtTy6Aq4DvfRgV9Lzj6Ma+I4eMswnwFZ8
         +34uPnH99zEBMlZYgxLUlGXkU2WhvUTDAkwMi23llmkgIuTKTgrlIYOevSJyunuoUCLI
         1vT5qf4wy2PidaVcZzeNC3hna3oBsxMRURyQjjuhG2/3/Q00DMlG06Ivea2BXcmBmf3L
         OapA==
X-Gm-Message-State: AOJu0YzRTL7mxfAjO/9chI7LOTX0Qah1YyuJxe3VfRkIoXDK82S/s6MD
	8w1yR6fYfYYOTibVtlSPb6aj3EjHShZ3DMfNasXIdJdd6nlAbCExo0LggMUSX38gdTzSNa44Xq7
	U2ne6uqiZIryHpzPysG9S7BUWor+q66E=
X-Gm-Gg: ASbGncs0Xoa6ZCyH5DRhZqBra6bia+2H6NCVp9oB5bYs6dqiiwqNy5GGdoFQgikddSq
	kTwIMjgUsrsvbLYiK7ArSWpkSAdWzRerUbnW9SU5Na0E4ettP68sSNegZbm9z90xpnz+91yjLdq
	PZmhc/51930u7WJ/0mHearCCqNB55YK2nvfiY5GeMtNqCU
X-Google-Smtp-Source: 
 AGHT+IFoOmvivVHr1/P9PH2PkOsNKEGSj+CX/fbHkqdt0Rvv8foIShRs/BXpfJBAt/Khnzcjcxc20uJ75Ek2XB+U96E=
X-Received: by 2002:a05:6512:1054:b0:54e:8135:33dc with SMTP id
 2adb3069b0e04-553b687e94amr1805300e87.14.1750049738770; Sun, 15 Jun 2025
 21:55:38 -0700 (PDT)
MIME-Version: 1.0
References: 
 <CA+wokJ_EsMBKGG--J9_Q_dmFh-jAqjhQaaKo4_Huzg0X1aBpag@mail.gmail.com>
In-Reply-To: 
 <CA+wokJ_EsMBKGG--J9_Q_dmFh-jAqjhQaaKo4_Huzg0X1aBpag@mail.gmail.com>
From: Tim Gerber <tggerber@gmail.com>
Date: Sun, 15 Jun 2025 23:55:27 -0500
X-Gm-Features: AX0GCFtPOJ3aBuv03FNzvEXq9g6tkylB-ZQJWNE15SKVBD5WRrkUTTdEhtFCa7s
Message-ID: 
 <CAPKih1z-uoEVZC9j3iyY-XyzuRsm15JUtOg3c7tbLBe7-984Hw@mail.gmail.com>
Subject: Re: 'Sharing' data across different database.
To: Edwin UY <edwin.uy@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000004cfa30637a93597"
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/CAPKih1z-uoEVZC9j3iyY-XyzuRsm15JUtOg3c7tbLBe7-984Hw%40mail.gmail.com>
Precedence: bulk

--00000000000004cfa30637a93597
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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=E2=80=AFPM Edwin UY <edwin.uy@gmail.com> wrot=
e:

> Hi,
>
> Is using Foreign Data Wrapper the only available option to access data
> amongst databases?
>
>
> Regards,
> Edd
>

--00000000000004cfa30637a93597
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Foreign data wrapper=C2=A0or a dblink (<a href=3D"https://=
www.postgresql.org/docs/current/contrib-dblink-function.html">https://www.p=
ostgresql.org/docs/current/contrib-dblink-function.html</a>) are your optio=
ns.=C2=A0 =C2=A0<div><br></div><div>Best Regards,</div><div>Tim=C2=A0</div>=
</div><br><div class=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr"=
 class=3D"gmail_attr">On Sun, Jun 15, 2025 at 11:40=E2=80=AFPM Edwin UY &lt=
;<a href=3D"mailto:edwin.uy@gmail.com">edwin.uy@gmail.com</a>&gt; wrote:<br=
></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;=
border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><=
div dir=3D"ltr"><div><span style=3D"font-family:monospace">Hi,</span></div>=
<div><span style=3D"font-family:monospace"><br></span></div><div><span styl=
e=3D"font-family:monospace">Is using Foreign Data Wrapper the only availabl=
e option to access=C2=A0data amongst databases?</span></div><div><br></div>=
<div><span style=3D"font-family:monospace"><br></span></div><div><span styl=
e=3D"font-family:monospace">Regards,</span></div><div><span style=3D"font-f=
amily:monospace">Edd</span></div></div>
</div>
</blockquote></div>

--00000000000004cfa30637a93597--