Re: checksumming data

On Tue, Jan 04, 2005 at 10:26:26AM +0200, Can Burak Cilingir wrote:

> the need for md5summing by the help of database is just curiosity. I am
> summing before insert which was enough already.

The digest() function in contrib/pgcrypto takes a BYTEA or TEXT
argument, which presumably means you'd have to read the entire file
into memory (or can it be mmap()'ed?  I'm not sure).  For large
data this isn't practical, so you might want to look for something
that can build the hash in blocks.  See the pgcrypto source code
for examples.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/