venkatrao.b@xxxxxxx wrote:
Hello ,
I want to read oracle database table data from postgre. (like in
oracle we can use database links, is there something like this
available in postgre).
I tried below -
select dblink_connect('host=.., dbname=..user=.. pwd=..'); but it is
giving error database refused connection. Do i need to add anything in
oracle datbase server tnsnames. how should be this entry.(since here
we are connecting oracle to postgre and not the oracle to oracle)
postgresql's dblink functions can only connect to other postgresql
databases. it has no idea how to connect to Oracle, or any other sort
of database.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general