Skip site navigation (1) Skip section navigation (2)

Re: Quoting "

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Andy Anderson" <aanderson(at)amherst(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Quoting "
Date: 2008-04-30 15:52:39
Message-ID: dcc563d10804300852r7721a7e3q5cb6bb0cf5b83441@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-docspgsql-general
On Wed, Apr 30, 2008 at 7:10 AM, Andy Anderson <aanderson(at)amherst(dot)edu> 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.)

Why are you using php's addslashes() function?  Is there something
missing from pg_escape_string()???  Or are you doing something else
I'm not thinking of?

In response to

  • Quoting " at 2008-04-30 13:10:38 from Andy Anderson

Responses

pgsql-docs by date

Next:From: Andy AndersonDate: 2008-04-30 16:51:45
Subject: Re: Quoting "
Previous:From: Andy AndersonDate: 2008-04-30 14:33:19
Subject: Re: Quoting "

pgsql-general by date

Next:From: Alvaro HerreraDate: 2008-04-30 16:13:15
Subject: Re: Why is postgres autovacuuming a table that is neverupdated?
Previous:From: Joseph SDate: 2008-04-30 15:52:09
Subject: Re: Why is postgres autovacuuming a table that is never updated?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group