"Merlin Moncure" <merlin.moncure@rcsonline.com> writes:
>> Even binary data? ie. You could upload a binary string straight into
>> PQexecParams with no octal conversion?
> Well, what it means you do not have to escape data at the protocol level
> you don't have to be concerned about formatting the query string.
> However the server still may still need to interpret the data for
> storage...meaning for the bytea type at least you have to do octal
> encoding (at least that's what I do, I'd like nothing better than to be
> corrected on this point).
Not if you send the bytea parameter in binary format. If you send it in
text format that's true.
regards, tom lane