Home > mailing lists

How to get an md5/sha256 hash of a really large object in psql? - Mailing list pgsql-general

From	Alex Shan
Subject	How to get an md5/sha256 hash of a really large object in psql?
Date	July 29, 2023 09:42:35
Msg-id	CAAFmqa_MfByym+AyQAjq23_gd-p-=2c57KqXCr6D5BK_o46_Dg@mail.gmail.com Whole thread Raw
Responses	Re: How to get an md5/sha256 hash of a really large object in psql? (Erik Wienhold <ewie@ewie.name>)
List	pgsql-general

Tree view

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,

pgsql-general by date:

From: Michael Paquier
Date: 29 July 2023, 05:55:41
Subject: Re: backup_manifest rename to backup_manifest.old after successful postgres start up

From: "Peter J. Holzer"
Date: 29 July 2023, 11:59:07
Subject: Re: How to improve the performance of my SQL query？

How to get an md5/sha256 hash of a really large object in psql? - Mailing list pgsql-general

Previous

Next