On Mon, Apr 9, 2012 at 12:45 PM, Andrew Dunstan <andrew@dunslane.net> wrote:
>
>
> On 04/09/2012 12:14 PM, Dave Cramer wrote:
>>
>>
>> So I'm confused, once they link a file to an FDW can't you just read
>> it with an normal select ?
>>
>> What additional functionality will this provide ?
>>
>
>
>
> I'm confused about what you're confused about. Surely this won't be linking
> files to an FDW, but foreign DBMS tables, in anything you can access via
> JDBC. All you'll need on the postgres side is the relevant JDBC driver, so
> you'd have instant access via standard select queries to anything you can
> get a JDBC driver to talk to. That seems to me something worth having.
>
> I imagine it would look rather like this:
>
> CREATE FOREIGN DATA WRAPPER foodb HANDLER pljava_jdbc_handler
> OPTIONS (driver 'jdbc.foodb.org');
> CREATE SERVER myfoodb FOREIGN DATA WRAPPER foodb OPTIONS(host
> '1.2.3.4', user 'foouser', password 'foopw');
> CREATE FOREIGN TABLE footbl (id int, data text) SERVER myfoodb;
> SELECT * from footbl;
>
Well this is certainly more explanation than we have so far.
Is this the intended use case ?
Dave