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

From Kevin Jenkins
Subject Tips for storing files in the database
Date
Msg-id 4495723B.5020003@rakkar.org
Whole thread Raw
In response to Re: SQL query question  (Michael Glaesemann <grzm@seespotcode.net>)
Responses Re: Tips for storing files in the database
List pgsql-general
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 of data escaping to send a
query nor unescaping to get the file back.

All the files I'm adding are already loaded in memory with some binary
modifications.  I'm aware of the large object type, but this requires
that I write to disk first, which I hope isn't necessary.

pgsql-general by date:

Previous
From: "Marco Bizzarri"
Date:
Subject: Re: MySQL insert() and instr() equiv
Next
From: Tom Lane
Date:
Subject: Re: Tips for storing files in the database