Re: DBlink, postgres to DB2 - Mailing list pgsql-general

From Postgres India
Subject Re: DBlink, postgres to DB2
Date
Msg-id CAMU5o+_hbLsKzDSo=9O=QMm60zib2Yu77WZP=QkYapYkaB=CkA@mail.gmail.com
Whole thread Raw
In response to Re: DBlink, postgres to DB2  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re[2]: [GENERAL] DBlink, postgres to DB2
List pgsql-general
Thanks a lot Remi, Merlin and Pavel...........I will give it a try.

On Wed, Oct 22, 2014 at 6:36 AM, Merlin Moncure <mmoncure@gmail.com> wrote:
On Wed, Oct 22, 2014 at 5:56 AM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
> Hi
>
> try to use a Perl implementation https://github.com/davidfetter/DBI-Link
>
> There is a DBD driver for DB2 http://search.cpan.org/dist/DBD-DB2/DB2.pod
>
> Or you can use a mentioned fdw wrapper - there is ODBC wrapper
> https://wiki.postgresql.org/wiki/Foreign_data_wrappers#odbc_fdw and you can
> access DB2 via generic ODBC DB2 driver

jdbc-fdw should work too.

https://github.com/atris/JDBC_FDW

merlin

pgsql-general by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Index scan vs indexonly scan method
Next
From: Daniel Begin
Date:
Subject: Re: Inconsistency between PgAdmin III GUI and SQL window ?