Re: escaping and quoting

From: Maarten Deprez <maartendeprez(at)scarlet(dot)be>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: escaping and quoting
Date: 2008-05-20 14:48:59
Message-ID: 1211294939.13908.6.camel@simbelmyne.be.eu.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I wrote:
> My dbmail server using postgresql produces a lot of warnings about '\\'
> in strings. The particular string it is complaining about is escaped by
> EscapeBytea, and included in single quotes (not E''). Is it all right to
> set standard_compliant_strings to on?

Laurenz Albe wrote:
> Depends.

Okay, what do you need to know? It can be any string, a part of an email
message. Should strings escaped by EscapeBytea be included in "''", or
"E''" in the SQL command, to avoid the warning?

Greetings,
Maarten

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message George Pavlov 2008-05-20 14:59:37 Re: DB page cache/query performance
Previous Message Kevin Hunter 2008-05-20 14:30:22 [Fwd: Re: i am looking for postgresql hosting server]