PostgreSQL Foreign Data Wrapper for Oracle
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
- Supports gathering statistics with ANALYZE from PostgreSQL 9.2 on
Requirements:
- PostgreSQL 9.1 or better
- Oracle client 10.1 or better
- For EXPLAIN VERBOSE, SELECT privileges on V$SQL and V$SQL_PLAN
oracle_fdw is still in Beta. Please report problems on the project's bug tracker or mailing list.
The oracle_fdw project is a PostgreSQL Community project that is a part of the pgFoundry.
