| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Charlin Barak <charlinbarak(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: ora2pg and invalid command \N |
| Date: | 2018-03-16 18:03:53 |
| Message-ID: | 840d62fe-5970-6d72-751c-f918f6fb87ef@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Victoria | 2018-03-16 18:05:17 | Re: Nvim as external editor in psql as Postgres root user - .vimrc (environment?) issue |
| Previous Message | Adrian Klaver | 2018-03-16 17:58:10 | Re: Nvim as external editor in psql as Postgres root user - .vimrc (environment?) issue |