Re: Crypt() encryption

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: czhang(at)theinformationforge(dot)com
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Crypt() encryption
Date: 2004-04-10 01:06:48
Message-ID: 200404100106.i3A16mo12268@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Christina Zhang wrote:
> Hello,
>
> We are planning to use Crypt() to encrypt the application level
> users' passwords. Our question is that which encryption method
> the Crypt() is using? (DES, or some other encryption algorithms?)
> Because we concern about the strenth of the Crypt().

Use MD5. That is the best method for this. There is an md5() function
already in the database, and there is /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-sql by date

  From Date Subject
Next Message scott.marlowe 2004-04-10 01:23:51 Re: pgsql multi-database queries
Previous Message Greg Stark 2004-04-09 22:43:25 Re: SQL challenge--top 10 for each key value?