Postgres Pro
Downloads
Home   >   mailing lists

Re: Escaping special characters - Mailing list pgsql-general

From Thom Brown
Subject Re: Escaping special characters
Date
Msg-id bddc86150903170539r6f4e885at47c74a6f75ff8736@mail.gmail.com
Whole thread Raw
In response to Re: Escaping special characters  (Thom Brown <thombrown@gmail.com>)
List pgsql-general
Tree view

2009/3/17 Thom Brown <thombrown@gmail.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

pgsql-general by date:

Previous
From: Sam Mason
Date:
Subject: Re: Escaping special characters
Next
From: Tom Lane
Date:
Subject: Re: different results for large objects