Hello 2010/11/16 Hu, William <h...@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 > ta...@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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
