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

Re: BUG #4398: Backslashes get escaped despite of backslash_quote=off

From: "Rainer Glueck" <rainer(dot)glueck(at)netminds(dot)de>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4398: Backslashes get escaped despite of backslash_quote=off
Date: 2008-09-05 08:22:54
Message-ID: 48C1087E.10389.3CFE48D@rainer.glueck.netminds.de (view raw or flat)
Thread:
Lists: pgsql-bugs
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello Tom,

On 4 Sep 2008 at 12:53, Tom Lane wrote:
>
> "Rainer Glueck" <rainer(dot)glueck(at)netminds(dot)de> writes:
> > How can backslashes be stopped from escaping themselves in like-statements
> 
> Use ESCAPE ''.  There isn't any other way provided.
> ...
> if you have no escape character then you have no way to quote % and _

Yes, that's true indeed.
And since I learned that the escape clause is recommended to cope
with that matter not only by PostgreSQL, but also by Transact-SQL,
I'm going to adapt my database connector this way, withdraw this topic
and thank you for pushing me a little bit more to enlightenment. :)

Regards,
Rainer




-----BEGIN PGP SIGNATURE-----
Version: idw's PGP-Frontend 5.1.0.0 / 4-2006 + PGP 6.5.8
Comment: KEY: 0x231D96D8 - FP: 9E01C5D7 7041D0C4 804F4705 76216606 231D96D8

iQA/AwUBSMDeV3YhZgYjHZbYEQKv3gCgx6UWMbVLsym6hb8/DG91JMNX3OAAoK9M
NrpA0F3AGjPeqacOks2AVtJe
=8SXN
-----END PGP SIGNATURE-----

In response to

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2008-09-05 23:53:52
Subject: Re: BUG #4374: pg_restore does not restore public schema comment
Previous:From: Joachim UngerDate: 2008-09-05 05:37:39
Subject: BUG #4402: Column expansion: date comes wthout a cast

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