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-----
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 |