Foreign Data Wrapper for Oracle (Beta) released

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