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