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

Tk421 wrote:
> I'm looking for a function that returns a md5 encryption for
> postgreSQL 7.3.4
>
> I've found that this function exists on version 7.4, but I have had
> problems installing it on my Windows XP with Cygwin, so I need to
> found it for version 7.3

See contrib/pgcrypto

HTH,

Joe

    I've been looking at contrib/pgcrypto but it hasn't any information
about md5 encryption


Víctor Robador Capel

Análisis de Sistemas y Programación

www.creativosdolmen.com
----- Original Message -----
From: "Joe Conway" <mail@joeconway.com>
To: "Tk421" <vrobador@vodafone.es>
Cc: <pgsql-general@postgresql.org>
Sent: Wednesday, November 03, 2004 5:49 PM
Subject: Re: [GENERAL] MD5 for PostgreSQL 7.3.4


> Tk421 wrote:
> > I'm looking for a function that returns a md5 encryption for
> > postgreSQL 7.3.4
> >
> > I've found that this function exists on version 7.4, but I have had
> > problems installing it on my Windows XP with Cygwin, so I need to
> > found it for version 7.3
>
> See contrib/pgcrypto
>
> HTH,
>
> Joe
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
>

Tk421 wrote:
>     I've been looking at contrib/pgcrypto but it hasn't any information
> about md5 encryption


Sure it does. See README.pgcrypto:

"SQL FUNCTIONS
=============

         If any of arguments are NULL they return NULL.

digest(data::bytea, type::text)::bytea

         Type is here the algorithm to use. E.g. 'md5', 'sha1', ...
         Returns binary hash."

Joe