On Mon, Sep 1, 2008 at 1:03 AM, James Kitambara <[EMAIL PROTECTED]> 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. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
