Re: Data Encryption in PostgreSQL, and a Tutorial.

From: <btober(at)computer(dot)org>
To: <dbadekas(at)aia(dot)gr>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Data Encryption in PostgreSQL, and a Tutorial.
Date: 2004-05-11 15:59:21
Message-ID: 64898.216.238.112.88.1084291161.squirrel@$HOSTNAME
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> Dias Bantekas wrote:
>
>> does any one know how to get an md5()-like hash function using
>> pgcrypto for postgresql 7.3 ? without upgrading to 7.4
>>
>> Thanks for any input.
>
> SELECT encode(digest(v_password, 'md5'), 'hex');

BTW,

/usr/share/pgsql/contrib/pgcrypto.sql

is the script that defines the encode and digest functions.

--Berend Tober

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dennis Gearon 2004-05-11 16:06:35 bytea
Previous Message Thomas LeBlanc 2004-05-11 15:54:00 How to move data from 1 database to another?