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) .
If we can pass the CSV instead of .txt or any other format. Do we have any solution. if Yes Can you please give me some
example.
Many Thanks,
Vinod
-----Original Message-----
From: Andrew Gierth <andrew@tao11.riddles.org.uk>
Sent: Friday, May 3, 2019 1:37 PM
To: Guntry Vinod <GV00619735@TechMahindra.com>
Cc: Adrian Klaver <adrian.klaver@aklaver.com>; ravikrishna@mail.com; pgsql-general@postgresql.org; Venkatamurali
KrishnaGottuparthi <VG00114307@TechMahindra.com>; Biswa Ranjan Dash <BD00617837@TechMahindra.com>
Subject: Re: Back Slash \ issue
>>>>> "Guntry" == Guntry Vinod <GV00619735@TechMahindra.com> writes:
Guntry> Hi Team,
Guntry> We are using the below command
Guntry> COPY <<TableName>> from 'C:\Data_Dump\ABC.txt' DELIMITER '|';
COPY in postgresql expects one of two data formats; since you did not specify CSV, in this case it's expecting the
defaultpostgresql format which requires the use of \ for escapes like \r, \n, \t, \\, \012 and for the default NULL
specificationof \N.
If you use this format it is therefore your responsibility to ensure that any literal \ characters in the data are
escapedas \\, and that any literal appearance of the delimiter character or a newline is also escaped.
See https://www.postgresql.org/docs/current/sql-copy.html under "Text format".
--
Andrew (irc:RhodiumToad)
============================================================================================================================
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.
============================================================================================================================
