Re: md5 function

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: ivan <iv(at)psycho(dot)pl>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: md5 function
Date: 2004-03-27 22:07:11
Message-ID: 200403272207.i2RM7BW28555@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

ivan wrote:
>
> can you create second md5 function like TEXT md5(TEXT string, VARCHAR
> salt); ? , This is using in shadow passwords and give more combination of
> this same password.

Yes, please see src/contrib/pgcrypto.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Manuel Sugawara 2004-03-28 00:56:45 default enconding
Previous Message Manfred Koizar 2004-03-27 22:03:09 Re: PostgreSQL block size vs. LVM2 stripe width