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