md5 function

Started by ivanalmost 22 years ago2 messages

iv@psycho.pl

almost 22 years ago

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

Bruce Momjian

pgman@candle.pha.pa.us

almost 22 years ago

In reply to: ivan (#1)

Re: md5 function

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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073