Re: [GENERAL] Tips for storing files in the database

2006-06-18 Thread Tom Lane
Kevin Jenkins <[EMAIL PROTECTED]> 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

[GENERAL] Tips for storing files in the database

2006-06-18 Thread Kevin Jenkins
Is there a way to send and read binary data directly from memory, without escaping characters, for SELECT and INSERT queries? This is for a file repository, such as in source control. I saw in the manual the section on bytea and binary data, but I don't want to go through hundreds of megabytes