Thanks for your anwers. They have been very useful.

Thanks again.


----- Mensaje original ----
De: John DeSoi <[EMAIL PROTECTED]>
Para: Eugenio Flores <[EMAIL PROTECTED]>
CC: Andrej Ricnik-Bay <[EMAIL PROTECTED]>; PostgreSQL <pgsql-sql@postgresql.org>
Enviado: jueves, 1 de marzo, 2007 5:25:28
Asunto: Re: [SQL] 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


        
        
                
___________________________________________________________ 
Do You Yahoo!? 
La mejor conexión a Internet y <b >2GB</b> extra a tu correo por $100 al mes. 
http://net.yahoo.com.mx 

Reply via email to