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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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