Re: ora2pg and invalid command \N

On Fri, Mar 16, 2018 at 8:28 PM, Adrian Klaver wrote: > On 03/16/2018 11:36 AM, Charlin Barak wrote: >> >> Thanks for your response. >> >> the NULL values from Oracle were indeed replaced by \N in the data output. >> How do I go about loading this file? I hope I do not

Re: ora2pg and invalid command \N

On 03/16/2018 11:36 AM, Charlin Barak wrote: Thanks for your response. the NULL values from Oracle were indeed replaced by \N in the data output. How do I go about loading this file? I hope I do not have to temporary replace \N with a string in the flat file and then later update in

Re: ora2pg and invalid command \N

Thanks for your response. the NULL values from Oracle were indeed replaced by \N in the data output. How do I go about loading this file? I hope I do not have to temporary replace \N with a string in the flat file and then later update in Postgres. Thanks. 102 48299 50 C 3 \N

Re: ora2pg and invalid command \N

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

Re: ora2pg and invalid command \N

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

ora2pg and invalid command \N

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