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

From Adrian Klaver
Subject Re: ora2pg and invalid command \N
Date
Msg-id 840d62fe-5970-6d72-751c-f918f6fb87ef@aklaver.com
Whole thread Raw
In response to ora2pg and invalid command \N  (Charlin Barak <charlinbarak@gmail.com>)
List pgsql-general
On 03/16/2018 10:12 AM, Charlin Barak wrote:
> 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 

What was the complete command you used to generate the data file?

> the file via psql, I got lots of "invalid command \N" errors. The 

Can we see the complete error?

Also a section of the data file that contains the data that caused the 
error?

> resolution on the internet was not clear and was  not ora2pg related. 
> How do I resolve this issue? Can someone provide some guidance?
> 
> Thanks.
> 
> 
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Nvim as external editor in psql as Postgres root user - .vimrc(environment?) issue
Next
From: Victoria
Date:
Subject: Re: Nvim as external editor in psql as Postgres root user - .vimrc(environment?) issue