Re: Tips for storing files in the database

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kevin Jenkins <gameprogrammer(at)rakkar(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Tips for storing files in the database
Date: 2006-06-18 15:40:50
Message-ID: 28626.1150645250@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Kevin Jenkins <gameprogrammer(at)rakkar(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Greg Quinn 2006-06-18 16:02:11 Question about openSSL
Previous Message Kevin Jenkins 2006-06-18 15:33:15 Tips for storing files in the database