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

From: John DeSoi <desoi(at)pgedit(dot)com>
To: 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>
Subject: Re: How to store a password encripted in a user defined table
Date: 2007-03-01 13:25:28
Message-ID: 95880380-1F04-44B5-9353-BAB84955748E@pgedit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bart Degryse 2007-03-01 13:42:43 Re: How to store a password encripted in a user definedtable
Previous Message Shane Ambler 2007-03-01 11:39:43 Re: How to store a password encripted in a user defined table