Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into PostgreSQL.
Pull request 1783 added support for using oracle_fdw in combination with psql "\copy" and server-side COPY using BINARY stream. This pull request builds on 1783 to add support for CSV format.
BINARY requires an exact match between the FDW table data types on the destination table data types
CSV allows greater flexibility and supports non-identical data types as long as they are functionally-compatible with respect to the data stored
Key changes in the pull request:
Rename ORACLE_FDW_BINARY_COPY_MODE to ORACLE_FDW_COPY_MODE: local or server
Add ORACLE_FDW_COPY_FORMAT: binary or csv
Fix "server" mode oracle_fdw COPY which was broken by 1e9effc (in server mode the password is only visible via ps, etc on the host running PostgreSQL server, which is expected to have highly restricted access in production environments)
Pull request 1783 added support for using oracle_fdw in combination with psql "\copy" and server-side COPY using BINARY stream. This pull request builds on 1783 to add support for CSV format.
Key changes in the pull request:
ps, etc on the host running PostgreSQL server, which is expected to have highly restricted access in production environments)