Re: PostgreSQL and backslash escaping

Russ Tyndall <[email protected]> Mon, 08 Jun 2015 12:24:55 -0400
Newsgroups gmane.lisp.clsql.general
Message-ID <[email protected]>
CldoaWNoIGNsc3FsIGJhY2tlbmQgYXJlIHlvdSB1c2luZz8gIFBlcmhhcHMgdGhlIGBwb3N0Z3Jl
c3FsLXNvY2tldDNgIApiYWNrZW5kIHdpbGwgd29yayBiZXR0ZXIgZm9yIHlvdT8gIEl0IHVzZXMg
dGhlIGNsLXBvc3RncmVzIHByb2plY3QgdG8gCmNvbm5lY3QgdG8gdGhlIGRhdGFiYXNlIHZpYSBz
b2NrZXQgYXBpIHZlcnNpb24gMyBhbmQgdGVuZHMgdG8gYmUgbW9yZSB1cCAKdG8gZGF0ZSB0aGFu
IHRoZSBvdGhlciBwb3N0Z3JlcyBiYWNrZW5kcy4KClRoZXJlIGlzIGEgcGF0Y2ggdGhhdCBoYXMg
bm90IGJlZW4gbWFkZSBvZmZpY2lhbCB5ZXQgdG8gYWRkIHRoZSAiRSIgCnByZWZpeCB0byBzdHJp
bmdzIHVzaW5nIHRoZSBjbHNxbC1zeW50YXggW0UgIkhlcmUgaXMgYSBzdHJpbmcgd2l0aCAKZXNj
YXBlcyJdLiAgSSB3aWxsIHRyeSB0byBnZXQgdGhhdCBwdXNoZWQgdXAgdG8gYjkub3JnIGZvciBh
IHJlbGVhc2Ugc29vbi4KCmh0dHBzOi8vZ2l0aHViLmNvbS9Vbndhc2hlZE1lbWUvY2xzcWwvY29t
bWl0LzFjMTBjZGQyN2UyMTYwNGVjOWE3OGFjNTVjOWYxZTk4NTZiYmU5OWYKCkNoZWVycywKUnVz
cyBUeW5kYWxsClByb2dyYW1tZXIKQWNjZWxlcmF0aW9uLm5ldAoKT24gMDYvMDcvMjAxNSAwNDox
NSBQTSwgSm9obiBEZVNvaSB3cm90ZToKPj4gT24gSnVuIDcsIDIwMTUsIGF0IDg6MTYgQU0sIGpo
eWl1Z2podmJqaDIzNEBtYWlsLnJ1IHdyb3RlOgo+Pgo+PiBBZnRlciB0aGUgY2hhbmdlOgo+PiBz
ZWxlY3QgbGVuZ3RoKCdcXCcpOwo+PiAtPiAyCj4+IHNlbGVjdCBsZW5ndGgoJ1wnKTsKPj4gLT4g
MQo+Pgo+PiBTbyB0aGUgY29kZSBnZW5lcmF0ZWQgYnkgQ0xTUUwgbGVhZHMgdG8gdGhlIGJhY2tz
bGFzaGVzIGluIHRoZSBzdHJpbmcKPj4gYmVpbmcgZG91YmxlZCB3aXRoIHRoZSBuZXcgUG9zdGdy
ZVNRTCBkYXRhYmFzZXMuCj4+Cj4+IFdoYXQgaXMgdGhlIG1vc3QgcmVhc29uYWJsZSB3YXkgdG8g
aGFuZGxlIHRoaXM/Cj4KPiBOZXdlciBQb3N0Z3JlU1FMIHZlcnNpb24gcmVxdWlyZSB0aGUgIkUi
IHByZWZpeCBmb3Igc3RyaW5ncyB3aXRoIGVzY2FwZSBjaGFyYWN0ZXJzLiBFLmcuIGluIDkuNDoK
Pgo+IHNlbGVjdCBsZW5ndGgoRSdcXCcpOwo+IC0+IDEKPgo+IElmIHlvdSBkb24ndCBwcm92aWRl
IHRoZSBFLCAnXCcgaGFzIG5vIHNwZWNpYWwgbWVhbmluZy4KPgo+PiBDYXV0aW9uCj4+IElmIHRo
ZSBjb25maWd1cmF0aW9uIHBhcmFtZXRlciBzdGFuZGFyZF9jb25mb3JtaW5nX3N0cmluZ3MgaXMg
b2ZmLCB0aGVuIFBvc3RncmVTUUxyZWNvZ25pemVzIGJhY2tzbGFzaCBlc2NhcGVzIGluIGJvdGgg
cmVndWxhciBhbmQgZXNjYXBlIHN0cmluZyBjb25zdGFudHMuIEhvd2V2ZXIsIGFzIG9mIFBvc3Rn
cmVTUUwgOS4xLCB0aGUgZGVmYXVsdCBpcyBvbiwgbWVhbmluZyB0aGF0IGJhY2tzbGFzaCBlc2Nh
cGVzIGFyZSByZWNvZ25pemVkIG9ubHkgaW4gZXNjYXBlIHN0cmluZyBjb25zdGFudHMuIFRoaXMg
YmVoYXZpb3IgaXMgbW9yZSBzdGFuZGFyZHMtY29tcGxpYW50LCBidXQgbWlnaHQgYnJlYWsgYXBw
bGljYXRpb25zIHdoaWNoIHJlbHkgb24gdGhlIGhpc3RvcmljYWwgYmVoYXZpb3IsIHdoZXJlIGJh
Y2tzbGFzaCBlc2NhcGVzIHdlcmUgYWx3YXlzIHJlY29nbml6ZWQuIEFzIGEgd29ya2Fyb3VuZCwg
eW91IGNhbiBzZXQgdGhpcyBwYXJhbWV0ZXIgdG8gb2ZmLCBidXQgaXQgaXMgYmV0dGVyIHRvIG1p
Z3JhdGUgYXdheSBmcm9tIHVzaW5nIGJhY2tzbGFzaCBlc2NhcGVzLiBJZiB5b3UgbmVlZCB0byB1
c2UgYSBiYWNrc2xhc2ggZXNjYXBlIHRvIHJlcHJlc2VudCBhIHNwZWNpYWwgY2hhcmFjdGVyLCB3
cml0ZSB0aGUgc3RyaW5nIGNvbnN0YW50IHdpdGggYW4gRS4KPj4KPj4gSW4gYWRkaXRpb24gdG8g
c3RhbmRhcmRfY29uZm9ybWluZ19zdHJpbmdzLCB0aGUgY29uZmlndXJhdGlvbiBwYXJhbWV0ZXJz
IGVzY2FwZV9zdHJpbmdfd2FybmluZyBhbmQgYmFja3NsYXNoX3F1b3RlIGdvdmVybiB0cmVhdG1l
bnQgb2YgYmFja3NsYXNoZXMgaW4gc3RyaW5nIGNvbnN0YW50cy4KPgo+IFNlZSBodHRwOi8vd3d3
LnBvc3RncmVzcWwub3JnL2RvY3MvOS40L3N0YXRpYy9zcWwtc3ludGF4LWxleGljYWwuaHRtbAo+
Cj4KPiBKb2huIERlU29pLCBQaC5ELgo+Cj4KPgo+IF9fX19fX19fX19fX19fX19fX19fX19fX19f
X19fX19fX19fX19fX19fX19fX19fCj4gQ0xTUUwgbWFpbGluZyBsaXN0Cj4gQ0xTUUxAYjkuY29t
Cj4gaHR0cDovL2xpc3RzLmI5LmNvbS9jZ2ktYmluL21haWxtYW4vbGlzdGluZm8vY2xzcWwKCgpf
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fXwpDTFNRTCBtYWls
aW5nIGxpc3QKQ0xTUUxAYjkuY29tCmh0dHA6Ly9saXN0cy5iOS5jb20vY2dpLWJpbi9tYWlsbWFu
L2xpc3RpbmZvL2Nsc3FsCg==