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 <gv00619...@techmahindra.com>
Sent: Friday, May 3, 2019 2:35 PM
To: Matthias Apitz <g...@unixarea.de>
Cc: Andrew Gierth <and...@tao11.riddles.org.uk>; pgsql-gene...@postgresql.org;
Adrian Klaver <adrian.kla...@aklaver.com>; ravikris...@mail.com; Venkatamurali
Krishna Gottuparthi <vg00114...@techmahindra.com>; Biswa Ranjan Dash
<bd00617...@techmahindra.com>
Subject: RE: Back Slash \ issue
The postgre is running on Windows platform.
-----Original Message-----
From: Matthias Apitz <g...@unixarea.de>
Sent: Friday, May 3, 2019 2:32 PM
To: Guntry Vinod <gv00619...@techmahindra.com>
Cc: Andrew Gierth <and...@tao11.riddles.org.uk>; pgsql-gene...@postgresql.org;
Adrian Klaver <adrian.kla...@aklaver.com>; ravikris...@mail.com; Venkatamurali
Krishna Gottuparthi <vg00114...@techmahindra.com>; Biswa Ranjan Dash
<bd00617...@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 necessary changes, like
echo 'bla\foo' | sed 's/\\/\\\\/'
bla\\foo
matthias
--
Matthias Apitz, ✉ g...@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 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.
============================================================================================================================
