The most interesting (IMHO) FDW implementation I have used is an Australian
WFS service mounted locally as a Postgis table.
Not wonderful performance, but full spatial query functionality.
If performance was an issue, "create table as select * from FDW;" creates a
local cache...
Very useful fun
Thanks for the pointers!
I'll resume my task in the morning. If I get anywhere, I will post the
outcome.
R,
Gus
On Fri, Sep 6, 2024 at 9:35 PM Tom Lane wrote:
> Gus Spier writes:
> > If I understand the concepts correctly, FDW not only makes other
> databases
> > available, FDW also offers ac
Gus Spier writes:
> 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. Has anyone
> ever tried to connect to redis or elasticache?
2024年9月7日(土) 9:55 Gus Spier :
>
> I find myself in new territory, Foreign Data Wrappers (FDW). I stumble closer
> to success through the documentation, youtube videos, and various google
> resources. But I've come across a concept that intrigues me very deeply.
>
> If I understand the concepts co
> On Sep 6, 2024, at 17:55, Gus Spier 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: T
