Re: Escaping special characters

From: Thom Brown <thombrown(at)gmail(dot)com>
To: Neanderthelle Jones <elle(at)view(dot)net(dot)au>
Cc: PGSQL Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Escaping special characters
Date: 2009-03-17 12:39:50
Message-ID: bddc86150903170539r6f4e885at47c74a6f75ff8736@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2009/3/17 Thom Brown <thombrown(at)gmail(dot)com>

>
> I could be wrong, but shouldn't it be:
>
> INSERT INTO thing (name) VALUES ('Smith E'\\& Jones');
>
> I'm not sure why you're including an extra single or double-quote in the
> string.
>
> Regards
>
> Thom
>

Sorry, (damn copy & paste). I meant:

INSERT INTO thing (name) VALUES (E'Smith \\& Jones');

Thom

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-03-17 12:43:05 Re: [GENERAL] different results for large objects
Previous Message Sam Mason 2009-03-17 12:36:48 Re: Escaping special characters