Re: How to store a password encripted in a user defined table

MD5 is built-in to PostgreSQL. It is what PostgreSQL itself uses to  
hash passwords. For example:

select md5('this is my password');
               md5
----------------------------------
210d53992dff432ec1b1a9698af9da16
(1 row)



On Mar 1, 2007, at 6:06 AM, Eugenio Flores wrote:

> Thanks Andrej. But how can I use such algoritms in postgresql? arey  
> they defined in a function that I can call?
>
> Or, do I have to code one of those algorithm to use it in my  
> application?



John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL