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