Thread: is possible to read Oracle table from PostgreSQL?

I need to know if is possible to read oracle tables from PostgresSQL.
Can someone give me some help?



Thanks a lot

> I need to know if is possible to read oracle tables from PostgresSQL.
> Can someone give me some help?

It is theoretically possible, but depending on your skill level, possible
but difficult.

Starting with the latest versions of PostgreSQL, it is possible to return
multi-column result sets. All one would need to do is construct a
PostgreSQL extension that would query the Oracle database and return the
result set.

But, in general, I'd say no.

markw@mohawksoft.com wrote:
>>I need to know if is possible to read oracle tables from PostgresSQL.
>>Can someone give me some help?
>
>
> It is theoretically possible, but depending on your skill level, possible
> but difficult.
>
> Starting with the latest versions of PostgreSQL, it is possible to return
> multi-column result sets. All one would need to do is construct a
> PostgreSQL extension that would query the Oracle database and return the
> result set.

Hans-Jürgen Schönig modified contrib/dblink to do this. See:
http://archives.postgresql.org/pgsql-hackers/2003-06/msg00361.php

HTH,

Joe