Lists: | pgsql-hackers |
---|
From: | ivan <iv(at)psycho(dot)pl> |
---|---|
To: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | md5 function |
Date: | 2004-03-27 21:31:15 |
Message-ID: | Pine.LNX.4.58.0403272223460.23337@rex.anfa.pl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
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.
thanks, bye
ivan
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 |
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