Re: DBLINK - PostgreSQL to ORACLE

2014-10-20 20:43 GMT+02:00 Ferrell, Denise CTR NSWCDD, Z11 <
denise(dot)ferrell(dot)ctr(at)navy(dot)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
like multicorn
http://multicorn.org/foreign-data-wrappers/#sqlalchemy-foreign-data-wrapper

Regards

--
Matteo Durighetto

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

Italian PostgreSQL User Group <http://www.itpug.org/index.it.html>
Italian Community for Geographic Free/Open-Source Software
<http://www.gfoss.it>