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

From: "Dinesh Pandey" <dpandey(at)secf(dot)com>
To: "'PostgreSQL'" <pgsql-sql(at)postgresql(dot)org>
Subject: How to store and retrieve data with special characters (\n, \r, \f, \t) in the same format
Date: 2005-07-12 03:39:44
Message-ID: 200507120342.j6C3gR1O005118@postman.bayarea.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Browse pgsql-sql by date

  From Date Subject
Next Message Christoph Haller 2005-07-12 11:34:40 Re: PostgreSQL - ERROR: Cannot cast type character varying to
Previous Message TJ O'Donnell 2005-07-12 03:16:17 dynamically loaded functions