Have you tried adding ESCAPE '*\*' to the PostgreSQL COPY command?
https://www.postgresql.org/docs/10/sql-copy.html On Thu, May 2, 2019 at 12:54 PM Rob Sargent <robjsarg...@gmail.com> wrote: > > On 5/2/19 9:19 AM, Guntry Vinod wrote: > > 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 as Vinod\G. > > Have you tried somlething like > > sed 's/\\/\\\\/g' db2dump > db2dump.fixed > > > > > 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.kla...@aklaver.com] > > Sent: 02 May 2019 20:04 > > To: ravikris...@mail.com; Guntry Vinod > > Cc: pgsql-gene...@postgresql.org; Venkatamurali Krishna Gottuparthi; > Biswa Ranjan Dash > > Subject: Re: Back Slash \ issue > > > > On 5/2/19 7:30 AM, ravikris...@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.kla...@aklaver.com > > > ============================================================================================================================ > > > > Disclaimer: This message and the information contained herein is > proprietary and confidential and subject to the Tech Mahindra policy > 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. > > > > > ============================================================================================================================ > > > > > > > > > -- *Melvin Davidson* *Maj. Database & Exploration Specialist* *Universe Exploration Command – UXC* Employment by invitation only!
