Backslashes in 8.2 still escape, hwo to disable?

Started by Ken Johansonover 19 years ago4 messagesgeneral
Jump to latest
#1Ken Johanson
pg-user@kensystem.com

Hi,

I'm trying out the new 8.2 beta; the following query:

select 'ab\cd'; yields: abcd, not ab\cd.

Is there a setting I'd need to switch to enable the ANSI/ISO escape
behavior? I am using the JDBC driver; not sure if that could be the
culprit..

Thanks,
Ken

#2Jeff Davis
pgsql@j-davis.com
In reply to: Ken Johanson (#1)
Re: Backslashes in 8.2 still escape, hwo to disable?

On Fri, 2006-09-29 at 18:12 -0600, Ken Johanson wrote:

Hi,

I'm trying out the new 8.2 beta; the following query:

select 'ab\cd'; yields: abcd, not ab\cd.

Is there a setting I'd need to switch to enable the ANSI/ISO escape
behavior? I am using the JDBC driver; not sure if that could be the
culprit..

standard_conforming_strings

Regards,
Jeff Davis

#3Ken Johanson
pg-user@kensystem.com
In reply to: Jeff Davis (#2)
Re: PG Rocks! (was:Backslashes in 8.2 still escape, hwo

You guys, and PG ROCK!! The standard_conforming_strings mode works
beautifully... it is (was) the last low-level barrier to using PG in a
really professional/interop environment. And as I become familiar,
again, with how PG and it's tools have come along, I am SUPER impressed.
Many, many kudos!! Top notch!!

Ken

#4Bruce Momjian
bruce@momjian.us
In reply to: Ken Johanson (#3)
Re: PG Rocks! (was:Backslashes in 8.2 still escape,

Ken Johanson wrote:

You guys, and PG ROCK!! The standard_conforming_strings mode works
beautifully... it is (was) the last low-level barrier to using PG in a
really professional/interop environment. And as I become familiar,
again, with how PG and it's tools have come along, I am SUPER impressed.

Yea, we figured standard_conforming_strings was going to be needed badly
in certain environments.

--
Bruce Momjian bruce@momjian.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +