DBLINK - PostgreSQL to ORACLE

Поиск
Список
Период
Сортировка
Искать

DBLINK - PostgreSQL to ORACLE

От:
"Ferrell, Denise CTR NSWCDD, Z11" <denise.ferrell.ctr@navy.mil>
Дата:
Вложения:
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= dbname= port=1521 user= password=',
'select column1,
	Column2,
	Column3
FROM ') as t1 (column1 name, column2 . . .);


Thank you in advance.


Re: DBLINK - PostgreSQL to ORACLE

От:
"Gilberto Castillo" <gilberto.castillo@etecsa.cu>
Дата:


> 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?


You prove oracla_fdw?




Saludos,
Gilberto Castillo
La Habana, Cuba
--- 
This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE running at host imx3.etecsa.cu
Visit our web-site: , 

Re: DBLINK - PostgreSQL to ORACLE

От:
desmodemone <desmodemone@gmail.com>
Дата:


2014-10-20 20:43 GMT+02:00 Ferrell, Denise CTR NSWCDD, Z11 <denise.ferrell.ctr@navy.mil>:
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
Regards

--
Matteo Durighetto

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

Italian PostgreSQL User Group
Italian Community for Geographic Free/Open-Source Software

Re: DBLINK - PostgreSQL to ORACLE

От:
Albe Laurenz <laurenz.albe@wien.gv.at>
Дата:
Denise Ferrell wrote:
> 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?

No, dblink can only connect to PostgreSQL.

Try oracle_fdw: http://laurenz.github.io/oracle_fdw/

Yours,
Laurenz Albe
FAQ