How to store and retrieve data with special characters (\n, \r, \f, \t) in the same format - Mailing list pgsql-sql

From Dinesh Pandey
Subject How to store and retrieve data with special characters (\n, \r, \f, \t) in the same format
Date
Msg-id 200507120342.j6C3gR1O005118@postman.bayarea.net
Whole thread Raw
List pgsql-sql
<div class="Section1"><p class="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt;
font-family:Verdana">How to store and retrieve data with special characters (\n, \r, \f, \t) in the same format,
becausewhile storing <b><span style="font-weight:bold">\f</span></b> treats data in strange way.</span></font><p
class="MsoNormal"><fontface="Verdana" size="2"><span style="font-size:10.0pt; 
font-family:Verdana"> </span></font><p class="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt;
font-family:Verdana">Example: ‘This is sample data <b><font color="blue"><span
style="color:blue;font-weight:bold">\n</span></font></b><b><span style="font-weight:bold">\r</span></b>oot<b><span
style="font-weight:bold">\f</span></b>iles.txt,<b><span style="font-weight:bold">\r</span></b>oot<b><span
style="font-weight:
bold">\te</span></b>xt.txt’</span></font><p class="MsoNormal"><font face="Verdana" size="2"><span
style="font-size:10.0pt;
font-family:Verdana"> </span></font><p class="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt;
font-family:Verdana">Sol: One way replaces \ with \\</span></font><p class="MsoNormal"><font face="Verdana"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Verdana"> </span></font><p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size:
12.0pt">Thanks</span></font><p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size:
12.0pt">Dinesh</span></font></div>

pgsql-sql by date:

Previous
From: TJ O'Donnell
Date:
Subject: dynamically loaded functions
Next
From: Michael Fuhr
Date:
Subject: Re: dynamically loaded functions