I am dealing with radiology studies aka DICOM data) one would want an md5 function which streams in parts of a large object piece by piece using md5_update and m5_finalize or some such.
It didn't look like pgcrypto offers a streaming version either.
Anything I am overlooking ?
Hi,
I don't think that it is possible to stream the result of a query anyway, or is this some neat new feature?
I'm not sure if there is much to be gained from storing such large objects in a database. Also, the max size of a value is 1GB.
Maybe it would be better to do some file administration in the database, but not the actual storage. Then you could use a tool that does what you want on the bare file and maybe store the results in the database.
