Postgres Pro
Downloads
Home   >   mailing lists

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

From Miles Keaton
Subject pgcrypto : how to get SHA1(string) as a 40-char string, NOT binary string?
Date
Msg-id 59b2d39b05071300457030a7ad@mail.gmail.com
Whole thread Raw
Responses Re: pgcrypto : how to get SHA1(string) as a 40-char string, NOT binary string?
List pgsql-general
Tree view 
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 by date:

Previous
From: Josef Springer
Date:
Subject: CreateTable --> schema not found
Next
From: Bjørn T Johansen
Date:
Subject: Re: Windows version of PostgreSQL 8?