2018-03-16 18:12 GMT+01:00 Charlin Barak <charlinba...@gmail.com>: > 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. > > > > >
