Team, We had also tried importing the data by converting the data to a CSV file using \copy TABLE_NAME FROM 'G:\DB_Backup\FILE.csv' (format csv, null '\N'); Regards, Biswa -----Original Message----- From: Guntry Vinod <GV00619735@xxxxxxxxxxxxxxxx> Sent: Friday, May 3, 2019 2:35 PM To: Matthias Apitz <guru@xxxxxxxxxxx> Cc: Andrew Gierth <andrew@xxxxxxxxxxxxxxxxxxxx>; pgsql-general@xxxxxxxxxxxxxx; Adrian Klaver <adrian.klaver@xxxxxxxxxxx>; ravikrishna@xxxxxxxx; Venkatamurali Krishna Gottuparthi <VG00114307@xxxxxxxxxxxxxxxx>; Biswa Ranjan Dash <BD00617837@xxxxxxxxxxxxxxxx> Subject: RE: Back Slash \ issue The postgre is running on Windows platform. -----Original Message----- From: Matthias Apitz <guru@xxxxxxxxxxx> Sent: Friday, May 3, 2019 2:32 PM To: Guntry Vinod <GV00619735@xxxxxxxxxxxxxxxx> Cc: Andrew Gierth <andrew@xxxxxxxxxxxxxxxxxxxx>; pgsql-general@xxxxxxxxxxxxxx; Adrian Klaver <adrian.klaver@xxxxxxxxxxx>; ravikrishna@xxxxxxxx; Venkatamurali Krishna Gottuparthi <VG00114307@xxxxxxxxxxxxxxxx>; Biswa Ranjan Dash <BD00617837@xxxxxxxxxxxxxxxx> Subject: Re: Back Slash \ issue El día Friday, May 03, 2019 a las 08:45:02AM +0000, Guntry Vinod escribió: > Hi Andrew, > > So you mean to say we need to replace \\ in data. If so the data what we receive is huge chunk(we cannot open in notepad++ also) . > > ... Hi Guntry, What about piping the data on a Linux or any other UNIX (or even Cygwin on Windows) through a sed-Kommand to do the necessary changes, like echo 'bla\foo' | sed 's/\\/\\\\/' bla\\foo matthias -- Matthias Apitz, ✉ guru@xxxxxxxxxxx, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub 70 years of NATO - 70 years of wars (Jugoslavia, Afghanistan, Syria, ...) and 70 years of war preparation against Russia. -- PEACE instead of NATO ! ============================================================================================================================ 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. ============================================================================================================================
