search

darold / ora2pg

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.
http://www.ora2pg.com/
GNU General Public License v3.0
978 stars 341 forks source link

not sure if this is an issue \N #1720

Closed zorroMasked closed 4 months ago

zorroMasked commented 6 months ago

When exporting from oracle null byte transforms to "\N" without double quotes Postgres doesn't like \N

darold commented 6 months ago

This is not an issue, with COPY, NULL must be written \N and this is what Ora2Pg is doing. With INSERT statement NULL is used.