Re: DBLINK - PostgreSQL to ORACLE

[desmodemone <desmodemone@xxxxxxxxx>]

2014-10-20 20:43 GMT+02:00 Ferrell, Denise CTR NSWCDD, Z11 <denise.ferrell.ctr@xxxxxxxx>:

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.

Hello Denise,
                             you could use postgresql fdw  https://wiki.postgresql.org/wiki/Foreign_data_wrappers

like multicorn http://multicorn.org/foreign-data-wrappers/#sqlalchemy-foreign-data-wrapper

Regards

--

Matteo Durighetto

- - - - - - - - - - - - - - - - - - - - - - -

Italian PostgreSQL User Group

Italian Community for Geographic Free/Open-Source Software