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

[Alex Shan <3341018@xxxxxxxxx>]

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