Re: Data Encryption in PostgreSQL, and a Tutorial.

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