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?
> On 29/07/2023 08:42 CEST Alex Shan <3341...@gmail.com> wrote:
>
> 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
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