RE: Back Slash \ issue - Mailing list pgsql-general

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@TechMahindra.com> 
Sent: Friday, May 3, 2019 2:35 PM
To: Matthias Apitz <guru@unixarea.de>
Cc: Andrew Gierth <andrew@tao11.riddles.org.uk>; pgsql-general@postgresql.org; Adrian Klaver
<adrian.klaver@aklaver.com>;ravikrishna@mail.com; Venkatamurali Krishna Gottuparthi <VG00114307@TechMahindra.com>;
BiswaRanjan Dash <BD00617837@TechMahindra.com>
 
Subject: RE: Back Slash \ issue

The postgre is running on Windows platform.

-----Original Message-----
From: Matthias Apitz <guru@unixarea.de> 
Sent: Friday, May 3, 2019 2:32 PM
To: Guntry Vinod <GV00619735@TechMahindra.com>
Cc: Andrew Gierth <andrew@tao11.riddles.org.uk>; pgsql-general@postgresql.org; Adrian Klaver
<adrian.klaver@aklaver.com>;ravikrishna@mail.com; Venkatamurali Krishna Gottuparthi <VG00114307@TechMahindra.com>;
BiswaRanjan Dash <BD00617837@TechMahindra.com>
 
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
necessarychanges, like
 

echo 'bla\foo' | sed 's/\\/\\\\/'
bla\\foo

    matthias
--
Matthias Apitz, ✉ guru@unixarea.de, 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
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. 


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