RE: Back Slash \ issue

Hi Adrian\Kiran,

Below is the issue.

We are migrating from Db2 to Postgre.

The Db2 dump consists of back Slash \ with in the data [dump] , but postgre is not escaping the Slash.

For example if name consist of Vinod\G after the inserting the dump the value in postgre is VinodG where as I need it
asVinod\G. 

Since the dump is huge data I can't replace \  within the data to escape Slash.

We are using import utility provided by Postgre.

Can you please give me any solution in this regard?.

@kiran-let me also try solution you provided in the below mail.

Regards,
Vinod
_______________________________________
From: Adrian Klaver [adrian.klaver@aklaver.com]
Sent: 02 May 2019 20:04
To: ravikrishna@mail.com; Guntry Vinod
Cc: pgsql-general@postgresql.org; Venkatamurali Krishna Gottuparthi; Biswa Ranjan Dash
Subject: Re: Back Slash \ issue

On 5/2/19 7:30 AM, ravikrishna@mail.com wrote:
>  > We have dump from DB2 and trying to upload it Postgre.
> DB2 export command has an option to export it as CSV which quotes data
> so that any embedded
> lines or special characters inside the data is treated fine.  Does the
> csv format has quotes enclosing it ?

Please show the command you use to import into Postgres.
Also the error message you get.


--
Adrian Klaver
adrian.klaver@aklaver.com

============================================================================================================================

Disclaimer:  This message and the information contained herein is proprietary and confidential and subject to the Tech
Mahindrapolicy statement, you may review the policy at http://www.techmahindra.com/Disclaimer.html
<http://www.techmahindra.com/Disclaimer.html>externally http://tim.techmahindra.com/tim/disclaimer.html
<http://tim.techmahindra.com/tim/disclaimer.html>internally within TechMahindra. 


============================================================================================================================