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