RE: Back Slash \ issue

From: Biswa Ranjan Dash <BD00617837(at)TechMahindra(dot)com>
To: Guntry Vinod <GV00619735(at)TechMahindra(dot)com>, Matthias Apitz <guru(at)unixarea(dot)de>
Cc: Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "ravikrishna(at)mail(dot)com" <ravikrishna(at)mail(dot)com>, Venkatamurali Krishna Gottuparthi <VG00114307(at)TechMahindra(dot)com>
Subject: RE: Back Slash \ issue
Date: 2019-05-03 09:16:21
Message-ID: 78df4bf928bd4581a506be8f6332e110@BLREXCHMBX002.TechMahindra.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)TechMahindra(dot)com>
Sent: Friday, May 3, 2019 2:35 PM
To: Matthias Apitz <guru(at)unixarea(dot)de>
Cc: Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>; pgsql-general(at)postgresql(dot)org; Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>; ravikrishna(at)mail(dot)com; Venkatamurali Krishna Gottuparthi <VG00114307(at)TechMahindra(dot)com>; Biswa Ranjan Dash <BD00617837(at)TechMahindra(dot)com>
Subject: RE: Back Slash \ issue

The postgre is running on Windows platform.

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

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

matthias
--
Matthias Apitz, ✉ guru(at)unixarea(dot)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 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.

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Matthias Apitz 2019-05-03 10:03:46 Re: Back Slash \ issue
Previous Message Guntry Vinod 2019-05-03 09:04:34 RE: Back Slash \ issue