Re: Backslashes in data in version 8.1.2 - Mailing list pgsql-general

From Tom Lane
Subject Re: Backslashes in data in version 8.1.2
Date
Msg-id 14282.1140387781@sss.pgh.pa.us
Whole thread Raw
In response to Backslashes in data in version 8.1.2  (Mike Nolan <nolan@gw.tssi.com>)
Responses Re: Backslashes in data in version 8.1.2
List pgsql-general
Mike Nolan <nolan@gw.tssi.com> writes:
> When I moved up to 8.1.2 one of my PHP programs appears to be broken,
> I am getting backslashes in my data that I don't want.
> Investigating further, I have found some inconsistencies in how verion
> 8.1.2 handles data with backslashes in it:

This has not changed from prior versions.  It looks like you are
neglecting to allow for the fact that backslash is an escape character
both at the string-literal level and at the regex-pattern level.
Therefore you must write twice as many backslashes as you normally
would write in a regex pattern.  In particular, '\\\\' to match a
literal backslash.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: restoring under a different owner?
Next
From: Mike Nolan
Date:
Subject: Re: Backslashes in data in version 8.1.2