Re: string fields helps

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