| Lists: | pgsql-general |
|---|
| From: | Ken Johanson <pg-user(at)kensystem(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Backslashes in 8.2 still escape, hwo to disable? |
| Date: | 2006-09-30 00:12:21 |
| Message-ID: | 451DB665.5000408@kensystem.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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
| From: | Jeff Davis <pgsql(at)j-davis(dot)com> |
|---|---|
| To: | ken(at)kensystem(dot)com |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Backslashes in 8.2 still escape, hwo to disable? |
| Date: | 2006-09-30 00:39:05 |
| Message-ID: | 1159576745.31992.36.camel@dogma.v10.wvs |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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
| From: | Ken Johanson <pg-user(at)kensystem(dot)com> |
|---|---|
| To: | Jeff Davis <pgsql(at)j-davis(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: PG Rocks! (was:Backslashes in 8.2 still escape, hwo |
| Date: | 2006-09-30 04:46:57 |
| Message-ID: | 451DF6C1.7010304@kensystem.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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
| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | ken(at)kensystem(dot)com |
| Cc: | Jeff Davis <pgsql(at)j-davis(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: PG Rocks! (was:Backslashes in 8.2 still escape, |
| Date: | 2006-09-30 11:24:45 |
| Message-ID: | 200609301124.k8UBOj511681@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +