pgcrypto : how to get SHA1(string) as a 40-char string, NOT binary string?

Поиск
Список
Период
Сортировка
От Miles Keaton
Тема pgcrypto : how to get SHA1(string) as a 40-char string, NOT binary string?
Дата
Msg-id 59b2d39b05071300457030a7ad@mail.gmail.com
обсуждение исходный текст
Ответы Re: pgcrypto : how to get SHA1(string) as a 40-char string, NOT binary string?  (Michael Fuhr <mike@fuhr.org>)
Список pgsql-general
I have the contrib/pgcrypto installed.
I want to get the 40-character hash from SHA1

Example: SELECT digest('blue', 'sha1') would be:
4c9a82ce72ca2519f38d0af0abbb4cecb9fceca9

I was surprised and disappointed to get a binary-hash back.

Does anyone know how to get the regular 40-character string back from
SHA1 instead of the binary-hash?   (Or how to convert a binary-hash
into a-z0-9 chars?)

В списке pgsql-general по дате отправления:

Предыдущее
От: Josef Springer
Дата:
Сообщение: CreateTable --> schema not found
Следующее
От: Bjørn T Johansen
Дата:
Сообщение: Re: Windows version of PostgreSQL 8?