RE: Back Slash \ issue

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. 


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