Tips for storing files in the database

From: Kevin Jenkins <gameprogrammer(at)rakkar(dot)org>
To:
Cc: pgsql-general(at)postgresql(dot)org
Subject: Tips for storing files in the database
Date: 2006-06-18 15:33:15
Message-ID: 4495723B.5020003@rakkar.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-06-18 15:40:50 Re: Tips for storing files in the database
Previous Message Erin Sheldon 2006-06-18 14:33:43 Changing array subscripting to zero-offset