Обсуждение: MD5 hash function for PostgreSQL

Поиск
Список
Период
Сортировка

MD5 hash function for PostgreSQL

От
stephane@u-picardie.fr
Дата:
Hi,

Just wanted to let you know I posted a MD5 hash function for PostgreSQL,
based on a request I got for this kind of feature. The code is based on
the soundex module (as found in 7.0.2), with the original RSA MD5 code
found in the MD5 Perl module. (Please note the MD5 hash is not necessarily
cryptographically secure; I only implemented it because of the request I
got.)

The code can be downloaded from
  http://members.bellatlantic.net/~salnet/postgresql/
(I couldn't find an "upload" area on ftp.postgresql.org).

You can test the implementation by comparing the output of md5pg.sql with
the result of "md5sum test" (the "test" file is provided in the package).

Please forward any questions directly to me -- I do not subscribe to the
list!

S.


Re: MD5 hash function for PostgreSQL

От
Bruce Momjian
Дата:
FYI, we have a /contrib/pgcrypto in 7.1beta that has MD5.

>
> Hi,
>
> Just wanted to let you know I posted a MD5 hash function for PostgreSQL,
> based on a request I got for this kind of feature. The code is based on
> the soundex module (as found in 7.0.2), with the original RSA MD5 code
> found in the MD5 Perl module. (Please note the MD5 hash is not necessarily
> cryptographically secure; I only implemented it because of the request I
> got.)
>
> The code can be downloaded from
>   http://members.bellatlantic.net/~salnet/postgresql/
> (I couldn't find an "upload" area on ftp.postgresql.org).
>
> You can test the implementation by comparing the output of md5pg.sql with
> the result of "md5sum test" (the "test" file is provided in the package).
>
> Please forward any questions directly to me -- I do not subscribe to the
> list!
>
> S.
>
>


--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026