I announce the first Beta release of oracle_fdw.
Project home page: http://oracle-fdw.projects.postgresql.org/
oracle_fdw is a PostgreSQL extension that provides a Foreign
Data Wrapper for easy and efficient read access to Oracle
databases.
Features:
* Uses the new standard compliant SQL/MED environment of PostgreSQL 9.1
* Supports translation of Oracle data types to similar PostgreSQL data
types
* WHERE conditions are propagated to Oracle where possible
* Only the required Oracle table columns are selected
* EXPLAIN shows the remote query, EXPLAIN VERBOSE the Oracle execution
plan
* Should compile and run on all platforms supported by Oracle Client
and PostgreSQL
* Works with the regular Oracle client and Oracle Instant Client
* Installable with a single CREATE EXTENSION command
* Oracle connections are cached for the duration of the PostgreSQL
session
* Supports Oracle external authentication to avoid storing passwords in
the database
* Uses Oracle prefetching for high performance
Requirements:
* PostgreSQL 9.1 or better
* Oracle client 10.1 or better
* For EXPLAIN VERBOSE, SELECT privileges on V$SQL and V$SQL_PLAN
Enjoy!
Yours,
Laurenz Albe