Обсуждение: md5 function

Поиск
Список
Период
Сортировка

md5 function

От
ivan
Дата:
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, byeivan

Re: md5 function

От
Bruce Momjian
Дата:
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,
Pennsylvania19073