Re: How to get an md5/sha256 hash of a really large object in psql?

Great, thanks a lot! I will test it on my system. Myself, I tried to do it in C with libpq, but got stuck at reading a LO... On Sat, 29 Jul 2023 at 19:57, Erik Wienhold wrote: > > “SELECT md5(lo_get(loid));” doesnt work — “large object is too large”. > > > > Is there any other way to do it?

How to get an md5/sha256 hash of a really large object in psql?

Hello, In my DB I have a large object over 4GB in size. I need to get its MD5 or SHA256 from within psql query, i.e. without exporting it to FS first. “SELECT md5(lo_get(loid));” doesnt work — “large object is too large”. Is there any other way to do it? Regards, Al