On Thu, 2009-04-23 at 21:33 +0200, Conrad Lender wrote:
> Hi.
> I would like our database abstraction to be able to handle both settings
> for standard_conforming_strings transparently, i.e. perform the escaping
> according to the current DB server settings. Since pg_escape_string() is
> aware of the current database connection, I had expected its behavior to
> change accordingly:
> And finally, would it be safe to always use the E'\\' syntax, regardless
> of how standard_conforming_strings is set on the server?
>
You can set standard_conforming_strings on the fly (see SET). So why not
just make sure it is always on if going through your layer. That way
none of this is an issue.
Sincerely,
Joshua D. Drake
--
PostgreSQL - XMPP: jdrake@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997