Re: Passing arrays of strings with backslashes as parameters

Florian Weimer <[email protected]> Mon, 07 Feb 2011 14:48:10 +0000

Newsgroups	gmane.comp.db.postgresql.dbdpg
Message-ID	<[email protected]>

* Dana Hudes:

> When you say "control characters" do you mean octal escaped
> sequences lilke \003 or do you mean you have a string with an ASCII
> 003 embedded in it? You should use former not latter.

quotemeta("\003") results in "\\\cC", which is interpreted by
PostgreSQL as '\cC', a different string.

-- 
Florian Weimer                <[email protected]>
BFK edv-consulting GmbH       http://www.bfk.de/
Kriegsstraße 100              tel: +49-721-96201-1
D-76133 Karlsruhe             fax: +49-721-96201-99