On Tue, Sep 25, 2001 at 08:42:04AM -0400, Mike Arace wrote:
>
> Is there a function out there for pg which allows you to generate a random
> number given a seed value? I'm trying to create a users table which would
> require the storage of a password in a database field, and I'm hesitant to
> put it in there in plain text, despite the fact I plan to put very tight
> restrictions on that particular table. Ideally, I would encode each letter
> one by one, using the random number generator with the previous letter as a
> seed for the next. I was told that certain unixes use a similar way to
> store their passwords, and it seemed to make sense for this application. I
> noticed that there is a rand() function, but I'm a little slow today and
> couldn't think a way to use that in this scenario. Any suggestions would be
>
> greatly appreciated.
Look into contrib/pgcrypto in CVS, or
http://www.l-t.ee/marko/pgsql/pgcrypto-0.3.tar.gz
in meantime. Gives you crypt() function not unlike in UNIXes.
Also gen_salt() for generating salts for it.
--
marko