Re: PQexecParams - Mailing list pgsql-hackers

From Tom Lane
Subject Re: PQexecParams
Date
Msg-id 6245.1110987555@sss.pgh.pa.us
Whole thread Raw
In response to Re: PQexecParams  ("Merlin Moncure" <merlin.moncure@rcsonline.com>)
List pgsql-hackers
"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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: read-only database
Next
From: "Moran.Michael"
Date:
Subject: contrib/pgcrypto