Re: Data Encryption in PostgreSQL, and a Tutorial.

btober@computer.org wrote:
>>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
> 
> 
> 
> 

thanks hlk, that's exactly what I was looking for.
Now I can create a md5() function and do my job!

encode is a native PG string function, it is not defined in pgcrypto.


Dias