Re: Tips for storing files in the database - Mailing list pgsql-general

Kevin Jenkins <gameprogrammer@rakkar.org> writes:
> Is there a way to send and read binary data directly from memory,
> without escaping characters, for SELECT and INSERT queries?

See PQexecParams --- an out-of-line bytea parameter, transmitted in
binary format, seems to be what you want on the send side.  For
reading, just ask for the result in binary format.

            regards, tom lane