Hello
2010/11/16 Hu, William <HuW@trimet.org>:
> Hi, I have a need to select some data in a Oracle database from a Postgresql
> table. I know how to do this among Oracle instances, eg. Select * from
> table@another_instance.
>
>
>
> Are there similar approach without replicate the database tables?
>
with little bit programming yes. There is more ways. Probably the most
simple way is using a dblink
http://archives.postgresql.org/pgsql-hackers/2003-06/msg00361.php
other way, you can use a plperlu and DBI interface
http://www.pgsql.cz/index.php/PL/Perlu_-_Untrusted_Perl_%28en%29
Regards
Pavel Stehule
>
>
> Thanks in advance.