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


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match