MAY I HAVE YOUR ASSISTANCE - Mailing list pgsql-sql

 

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.

 

i.e. THE OUTPUT SHOULG LOOK LIKE THIS

 

    user_id      | user_name     |    password

    -------------------------------------------------------------

    0001         |  ADMIN           |   %3g4767teghh890)*

    0002         |  USER            |   #42@rwfs%6&&^*8

    0003         |  IT-MANAGER |   ^8Y3U(-43873GDG?

 

I appriciate for your assistance in advance,

 

Sincerely yours,

 

James Kitambara,

PostgreSQL user.