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 <ewie(at)ewie(dot)name> wrote:
> > “SELECT md5(lo_get(loid));” doesnt work — “large object is too large”.
> >
> > Is there any other way to do it?
>
> Is plpython3u [1] an option for you? In that case you can use Python's
> hashlib
> in a custom function and feed every page from pg_largeobject to a selected
> hash
> function.
> ...
> --
> Erik