Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3774.600.62\))
Subject: Re: Foreign Data Wrappers
From: Christophe Pettus <xof@thebuild.com>
In-Reply-To: <CAG8xnifz_V1Cr1fehMGS1nxhmAgX4Y4EUsvnvNb6DkB==AGP1w@mail.gmail.com>
Date: Fri, 6 Sep 2024 18:29:42 -0700
Cc: pgsql-general <pgsql-general@lists.postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <6FA30AD0-78FA-459E-BE85-334BFA1D0D2E@thebuild.com>
References: <CAG8xnifz_V1Cr1fehMGS1nxhmAgX4Y4EUsvnvNb6DkB==AGP1w@mail.gmail.com>
To: Gus Spier <gus.spier@gmail.com>
Archived-At: <https://www.postgresql.org/message-id/6FA30AD0-78FA-459E-BE85-334BFA1D0D2E%40thebuild.com>
Precedence: bulk


> On Sep 6, 2024, at 17:55, Gus Spier <gus.spier@gmail.com> wrote:
> If I understand the concepts correctly, FDW not only makes other =
databases available, FDW also offers access to .csv files, plain text, =
or just about anything that can be bullied into some kind of query-able =
order.

There two parts to FDWs: The code in the PostgreSQL core, and the FDW =
extension that is specific to type of the remote data source.  It's up =
to the plug-in to translate the remote data source into a format that =
appears as a foreign table, so the specifics of how the remote data =
source are mapped to the table depend on the plug-ins implementation.  =
You need to install the FDW extension in the PostgreSQL instance as you =
do with any extension.  There are a lot of different plug-ins, of =
varying degrees to maintenance, out in the ecosystem.  They definitely =
exist for Redis; I'm not sure about Elasticache.=