DBLINK - PostgreSQL to ORACLE
DBLINK - PostgreSQL to ORACLE
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.
Regards
--
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