Re: string fields helps

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

Bill Moran <wmoran(at)potentialtech(dot)com> writes:
> marcelo Cortez <jmdc_marcelo(at)yahoo(dot)com(dot)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