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 have to temporary
>> replace
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 Postgres.
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
1
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 resolution on
> the internet was 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 "
