Using PostgreSQL 9.3.4 on Linux Red-Hat platform.
Is there a way to use dblink to link from a PostgreSQL database to an Oracle database?
Tried the following and it's returning a SQL state: 08001
SELECT * from dblink('host=<hostname> dbname=<database> port=1521 user=<username> password=<password>',
'select column1,
Column2,
Column3
FROM <schema.table>') as t1 (column1 name, column2 . . .);
Thank you in advance.