Postgres Pro
Downloads
Home   >   mailing lists

Re: escaping and quoting - Mailing list pgsql-general

From Maarten Deprez
Subject Re: escaping and quoting
Date
Msg-id 1211294939.13908.6.camel@simbelmyne.be.eu.org
Whole thread Raw
In response to Re: escaping and quoting  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
Responses Re: escaping and quoting  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Kevin Hunter
Date:
Subject: [Fwd: Re: i am looking for postgresql hosting server]
Next
From: "George Pavlov"
Date:
Subject: Re: DB page cache/query performance