Postgres Pro
Downloads
Home   >   mailing lists

Re: Data Encryption in PostgreSQL, and a Tutorial. - Mailing list pgsql-general

From Michal Hlavac
Subject Re: Data Encryption in PostgreSQL, and a Tutorial.
Date
Msg-id 40A0F442.8020909@medium13.sk
Whole thread Raw
In response to Re: Data Encryption in PostgreSQL, and a Tutorial.  (Dias Bantekas <dbadekas@aia.gr>)
Responses Re: Data Encryption in PostgreSQL, and a Tutorial.
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: Data Encryption in PostgreSQL, and a Tutorial.
Next
From: "Thomas LeBlanc"
Date:
Subject: How to move data from 1 database to another?