MD5 encryption, Was: Multilingual database

From: "M(dot) Bastin" <marcbastin(at)mindspring(dot)com>
To: Dani Oderbolz <oderbolz(at)ecologic(dot)de>, pgsql-novice(at)postgresql(dot)org
Subject: MD5 encryption, Was: Multilingual database
Date: 2003-05-14 15:30:32
Message-ID: a0521060cbae8105699ac@[213.119.70.233]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Say Dani,

Do you know where I can find the specs of MD5, like it is implemented in pgsql?
I've been doing google searches on MD5 a week ago or so, but didn't
come up with any explanation on how to program MD5 encryption. I
didn't even find *the* MD5, but all kinds of derivated encryption
techiques--without explanations.

Thanks,

Marc

At 5:02 PM +0200 5/14/03, Dani Oderbolz wrote:
>M. Bastin wrote:
>
>>At 6:11 PM +0800 5/14/03, Terence Ng wrote:
>>
>>>Thank you very much for your patience. May I have one
>>>more question?
>>>May I put the login and password of my customers in
>>>the same table containing my customers name and
>>>address?
>>
>>
>>It is a convenient thing to do, but it's not very safe unless you
>>somehow store this information encrypted, or at least, scrambled.
>
>If you use a Hash Functions such as MD5 to store it,
>I would say you are pretty save.
>
>The check you do in pseudo-code:
>
>If MD5(supplied_password) = = password_in_database Then
> Password Ok
>Else
> Password bad
>
>Cheers,
>Dani

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2003-05-14 16:16:18 Re: Limiting processor power on queries
Previous Message Josh Berkus 2003-05-14 15:21:01 Re: can't alter user with the postgres user