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@xxxxxxxxxxxxxxxxxxxxx Consulting, Development, Support, Training 503-667-4564 - http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
