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

Thanks for your anwers. They have been very useful.

Thanks again.

----- Mensaje original ----
De: John DeSoi <desoi(at)pgedit(dot)com>
Para: Eugenio Flores <eflores767003(at)yahoo(dot)com(dot)mx>
CC: Andrej Ricnik-Bay <andrej(dot)groups(at)gmail(dot)com>; PostgreSQL <pgsql-sql(at)postgresql(dot)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