Search Postgresql Archives

Tips for storing files in the database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux