Re: Data Encryption in PostgreSQL, and a Tutorial.

From: Michal Hlavac <hlavki(at)medium13(dot)sk>
To: Dias Bantekas <dbadekas(at)aia(dot)gr>, pgsql-general(at)postgresql(dot)org
Subject: Re: Data Encryption in PostgreSQL, and a Tutorial.
Date: 2004-05-11 15:41:54
Message-ID: 40A0F442.8020909@medium13.sk
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');

hlk

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas LeBlanc 2004-05-11 15:54:00 How to move data from 1 database to another?
Previous Message scott.marlowe 2004-05-11 15:40:18 Re: Data Encryption in PostgreSQL, and a Tutorial.