Re: How to get an md5/sha256 hash of a really large object in psql?
От
Alex Shan
Тема
Re: How to get an md5/sha256 hash of a really large object in psql?
Дата
Msg-id
CAAFmqa84GnfZzRm2svwed1_OSu7uuz4O7ApLYQC0+bfhGqLoVw@mail.gmail.com
Ответ на
Список
Дерево обсуждения
How to get an md5/sha256 hash of a really large object in psql? Alex Shan <3341018@gmail.com>
Re: How to get an md5/sha256 hash of a really large object in psql? Erik Wienhold <ewie@ewie.name>
Re: How to get an md5/sha256 hash of a really large object in psql? Alex Shan <3341018@gmail.com>
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@ewie.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
В списке pgsql-general по дате отправления
