Postgres Pro
Downloads
Home   >   mailing lists

ora2pg and invalid command \N - Mailing list pgsql-general

From Charlin Barak
Subject ora2pg and invalid command \N
Date
Msg-id CAPrg5cY7+_h+Eonx2tLLvPHBa93PKPpO0MWpcK+AK0FtXF43rA@mail.gmail.com
Whole thread Raw
Responses Re: ora2pg and invalid command \N  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: ora2pg and invalid command \N  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general
Tree view
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?

Thanks.




pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: STRING_AGG and GROUP BY
Next
From: Victoria
Date:
Subject: Nvim as external editor in psql as Postgres root user - .vimrc(environment?) issue