public inbox for [email protected]
help / color / mirror / Atom feedFrom: Christophe Pettus <[email protected]>
To: Gus Spier <[email protected]>
Cc: pgsql-general <[email protected]>
Subject: Re: Foreign Data Wrappers
Date: Fri, 6 Sep 2024 18:29:42 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAG8xnifz_V1Cr1fehMGS1nxhmAgX4Y4EUsvnvNb6DkB==AGP1w@mail.gmail.com>
References: <CAG8xnifz_V1Cr1fehMGS1nxhmAgX4Y4EUsvnvNb6DkB==AGP1w@mail.gmail.com>
> On Sep 6, 2024, at 17:55, Gus Spier <[email protected]> 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.
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Foreign Data Wrappers
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox