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            |   [EMAIL PROTECTED]&&^*8
    0003         |  IT-MANAGER |   ^8Y3U(-43873GDG?
 
I appriciate for your assistance in advance,
 
Sincerely yours,
 
James Kitambara,
PostgreSQL user.


      

Reply via email to