How to read oracle table's data from postgre

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)

Thanks in advance..

Regards,
Venkat
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain
confidential or privileged information. If you are
not the intended recipient, any dissemination, use,
review, distribution, printing or copying of the
information contained in this e-mail message
and/or attachments to it are strictly prohibited. If
you have received this communication in error,
please notify us by reply e-mail or telephone and
immediately and permanently delete the message
and any attachments. Thank you