Re: MAY I HAVE YOUR ASSISTANCE

On Mon, Sep 1, 2008 at 1:03 AM, James Kitambara
<jameskitambara@yahoo.co.uk> wrote:
>
> Please members of the PGSQL-SQL,
>
> I have one problem with the user table. I want to hide the password for the
> users.
>
> The table format is:
>
> user ( user_id, user_name, password)
>
> But I want the password to be encrypted so that when other users send the
> query:SELECT * FROM USER; The password must be gabbage.

Store it as an md5sum.  note that this is a one way function.  so
then, when someone logs in you md5 the password and compare it to the
md5 you saved in the db.