X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 560B852DC1 for ; Tue, 12 Jul 2005 18:09:05 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 90651-03 for ; Tue, 12 Jul 2005 21:08:57 +0000 (GMT) Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25]) by svr1.postgresql.org (Postfix) with ESMTP id C39BA52E50 for ; Tue, 12 Jul 2005 18:04:52 -0300 (ADT) Received: from postman.bayarea.net (postman.bayarea.net [205.219.84.13]) by svr2.postgresql.org (Postfix) with ESMTP id 62D98F0C4B for ; Tue, 12 Jul 2005 04:39:01 +0100 (BST) Received: from secf.com (209-128-104-244.bayarea.net [209.128.104.244]) by postman.bayarea.net (8.12.11/8.12.11) with ESMTP id j6C3gR1O005118 for ; Mon, 11 Jul 2005 20:42:27 -0700 (PDT) Message-Id: <200507120342.j6C3gR1O005118@postman.bayarea.net> Received: from dinesh by secf.com (MDaemon.PRO.v8.0.2.R) with ESMTP id md50001255407.msg for ; Mon, 11 Jul 2005 20:42:05 -0700 Reply-To: From: "Dinesh Pandey" To: "'PostgreSQL'" Subject: How to store and retrieve data with special characters (\n, \r, \f, \t) in the same format Date: Tue, 12 Jul 2005 09:09:44 +0530 Organization: Second Foundation India P Ltd. MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0029_01C586C1.784C3EC0" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 Thread-Index: AcWGk1gYWuyDYp5NSnSpFYFzbHzslg== X-Authenticated-Sender: dpandey@secf.com X-Spam-Processed: mail.secf.com, Mon, 11 Jul 2005 20:42:05 -0700 (not processed: message from valid local sender) X-MDRemoteIP: 220.227.32.11 X-Return-Path: dpandey@secf.com X-MDaemon-Deliver-To: pgsql-sql@postgresql.org X-MDAV-Processed: mail.secf.com, Mon, 11 Jul 2005 20:42:05 -0700 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.555 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, HTML_90_100, HTML_MESSAGE, MSGID_FROM_MTA_HEADER X-Spam-Level: X-Archive-Number: 200507/105 X-Sequence-Number: 22083 This is a multi-part message in MIME format. ------=_NextPart_000_0029_01C586C1.784C3EC0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit How to store and retrieve data with special characters (\n, \r, \f, \t) in the same format, because while storing \f treats data in strange way. Example: 'This is sample data \n \root\files.txt, \root\text.txt' Sol: One way replaces \ with \\ Thanks Dinesh ------=_NextPart_000_0029_01C586C1.784C3EC0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

How to store and retrieve data with special = characters (\n, \r, \f, \t) in the same format, because while storing \f treats data in strange = way.

 

Example: ‘This is sample data \n \root\files.txt, \root\text.txt’

 

Sol: One way replaces \ with = \\

 

Thanks

Dinesh

------=_NextPart_000_0029_01C586C1.784C3EC0--