newbie tries to get oracle db to select from postgresql

From: Ray Stell <ray(dot)stell(at)gmail(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: newbie tries to get oracle db to select from postgresql
Date: 2016-02-18 13:52:04
Message-ID: 56C5CC84.4020803@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Forgive me if this is a misplaced post.

I've been requested to get an Oracle 11g db to be able to select from a
postgresql 9.4 db and I've never gone here before. I was reading from here:
https://dbaspot.wordpress.com/2013/05/29/how-to-access-postgresql-from-oracle-database/
and it says to install odbc rpm on the oracle server: # yum install
postgresql91-odbc on the oracle server.

The one available is older:
> yum info postgresql-odbc.x86_64
Loaded plugins: priorities, ulninfo
Available Packages
Name : postgresql-odbc
Arch : x86_64
Version : 08.04.0200
Release : 1.el6
Size : 267 k
Repo : ol6_latest
Summary : PostgreSQL ODBC driver
URL : http://psqlodbc.projects.postgresql.org/
License : LGPLv2+
Description : This package includes the driver needed for applications
to access a
: PostgreSQL system via ODBC (Open Database Connectivity).

Is this ok to use with postgresql 9x? If not do I need to install
postgresql server components in order to build psqlodbc-09.05.0100?

Is there a better, detailed howto on this topic?

Browse pgsql-odbc by date

  From Date Subject
Next Message Ray Stell 2016-02-18 13:56:58 newbie tries to get oracle db to select from postgresql
Previous Message Inoue, Hiroshi 2016-02-18 12:29:25 Re: PostgreSQL: Autocommit through windows odbc driver doesnt work!!!