Re: string fields helps - Mailing list pgsql-general

From Tom Lane
Subject Re: string fields helps
Date
Msg-id 12517.1176769736@sss.pgh.pa.us
Whole thread Raw
In response to Re: string fields helps  (Bill Moran <wmoran@potentialtech.com>)
Responses Re: string fields helps  ("Michael Nolan" <htfoot@gmail.com>)
Re: string fields helps  (marcelo Cortez <jmdc_marcelo@yahoo.com.ar>)
List pgsql-general
Bill Moran <wmoran@potentialtech.com> writes:
> marcelo Cortez <jmdc_marcelo@yahoo.com.ar> wrote:
>> I need to save data on rtf format but , postgres
>> refuses to storage for backslah or character's
>> problem's   any idea or vice are welcomed       best

> You need to escape the data before you insert it.  This is language-
> dependant, but any language that has PostgreSQL libraries will have
> functions to escape text data.

Also, given that his main problem seems to be with backslashes, using
8.2 and setting standard_conforming_strings = on might help.  It's still
the case that not using a proper escaping function will come back to
haunt you someday, though.

            regards, tom lane

pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: Re: digest data types?
Next
From: "Thomas F. O'Connell"
Date:
Subject: pg_standby + test_warm_standby: A Community Report