Re: Data Encryption in PostgreSQL, and a Tutorial.

[Michal Hlavac <hlavki@medium13.sk>]

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


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend