Re: MD5 for PostgreSQL 7.3.4

From: Joe Conway <mail(at)joeconway(dot)com>
To: Tk421 <vrobador(at)vodafone(dot)es>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: MD5 for PostgreSQL 7.3.4
Date: 2004-11-03 18:33:32
Message-ID: 4189247C.1070907@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Patrick Hatcher 2004-11-03 18:52:18 Number of months
Previous Message Jeff Bohmer 2004-11-03 18:33:26 Re: PostgreSQL on Linux PC vs MacOS X