Re: Performance problems testing with Spamassassin 3.1.0

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Michael Parker <parkerm@pobox.com>
Cc: pgsql-performance@postgresql.org
Date: 2005-08-01T04:42:30Z
Lists: pgsql-performance
Michael Parker <parkerm@pobox.com> writes:
> The next hurdle, and I've just posted to the DBD::Pg list, is
> escaping/quoting the token strings.

If you're trying to write a bytea[] literal, I think the most reliable
way to write the individual bytes is
	\\\\nnn
where nnn is *octal*.  The idea here is:
	* string literal parser takes off one level of backslashing,
	  leaving \\nnn
	* array input parser takes off another level, leaving \nnn
	* bytea input parser knows about backslashed octal values

Note it has to be 3 octal digits every time, no abbreviations.

			regards, tom lane