Re: Quoting "

Andy Anderson wrote:
> In a test I just did, the sequence \" (backslash double-quote) is
> interpreted as just a " inside of the E'...' string constant expression.
> This is great, since PHP's addslashes() sticks them in along with the
> other stuff I really need to quote like ' and \. But I see that \" isn't
> documented in the manual in section 4.1.2.1. I assume this is, in fact,
> standard behavior for Postgres? (Perhaps a comprehensive table might be
> a good idea at this point in the manual.)

craig=# SELECT E'\z\v\k\-';
?column?
----------
zvk-
(1 row)

From 4.1.2.1:

... "Any other character following a backslash is taken literally."

I didn't see any escape sequences being interpreted other than those
that're already documented in the section of 4.1.2.1 that describes E''
strings.

--
Craig Ringer