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 <[email protected]> Sent: Friday, May 3, 2019 1:37 PM To: Guntry Vinod <[email protected]> Cc: Adrian Klaver <[email protected]>; [email protected]; [email protected]; Venkatamurali Krishna Gottuparthi <[email protected]>; Biswa Ranjan Dash <[email protected]> Subject: Re: Back Slash \ issue >>>>> "Guntry" == Guntry Vinod <[email protected]> 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 default postgresql format which requires the use of \ for escapes like \r, \n, \t, \\, \012 and for the default NULL specification of \N. If you use this format it is therefore your responsibility to ensure that any literal \ characters in the data are escaped as \\, 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 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. ============================================================================================================================
