Re: ora2pg and invalid command \N

[Pavel Stehule <pavel.stehule@xxxxxxxxx>]

2018-03-16 18:12 GMT+01:00 Charlin Barak <charlinbarak@xxxxxxxxx>:

Hi,

I'm using ora2pg to migrate our Oracle database to Postgres. I was able to generate the data file using TYPE=COPY but when I attempted to load the file via psql, I got lots of "invalid command \N" errors. The resolution on the internet was not clear and was  not ora2pg related. How do I resolve this issue? Can someone provide some guidance?

\N is symbol for NULL. but \cmd are psql commands too. This behave means so psql lost synchronization and try to eval data like commands. psql import is tolerant - that means so source of this issue is lost usually. Try to import data with option ON_ERROR_STOP

 https://stackoverflow.com/questions/4480381/postgres-sql-fail-on-script-error

Regards

Pavel

Thanks.