Thanks Raymond !!!!
That is something I wanted! It's Great if it is already integrated in
Postgre! Superb. This is much more easy.
Thank you All.
Best,
Iñigo Barandiaran wrote:
Well, you can use the built-in md5 function for this purpose. For
instance, you could insert a password into the table with a statement
like:
insert into auth_data (user_id, password) values (1,
md5('test'));
And compare the supplied password with something like:
select true from auth_data where user_id = 1 and
password
=
md5('test');
You don't need to depend on an external library for this functionality;
it's built right into Postgres. Personally, in my own apps I write in
PHP, I use a combination of sha1 and md5 to hash user passwords,
without depending on Postgres to do the hashing, but the effect is
basically the same.
Raymond
|
