How do i create postgres to oracle dblink?

postgresql oracle11g postgresql-9.2 dblink
kinkajou picture kinkajou · Sep 25, 2013 · Viewed 35k times · Source

How do I create dblink in postgres 9.2 ? I want to be able to use it using @ link in oracle? I am using postgres 9.2 64bit. DBlink is from postgres 9.2 to Oracle 11g.

Answer

Leo picture Leo · Oct 18, 2013

If you need to access postgresql FROM Oracle:

http://dbaspot.wordpress.com/2013/05/29/how-to-access-postgresql-from-oracle-database/

If you need to access Oracle FROM postgresql:

http://pgxn.org/dist/oracle_fdw/

Related questions

PostgreSQL: Show tables in PostgreSQL

What's the equivalent to show tables (from MySQL) in PostgreSQL?

Read More
PostgreSQL: How to change PostgreSQL user password?

How do I change the password for PostgreSQL user?

Read More
PostgreSQL "DESCRIBE TABLE"

How do you perform the equivalent of Oracle's DESCRIBE TABLE in PostgreSQL (using the psql command)?

Read More