where i can see the password for the admin and users while using pgadmin res.users table password field contains ' ' NULL value.

Dear Aneesh,

You can see the admin password from backend database.

Step-1: Connect to that database from terminal or user interface

Step-2: Fire select query

Example (in terminal)

1. Please type below command in terminal.

 sudo su postgres

2. Then they will ask system password, Please enter it.

3. Then you will to write 

psql your_database_name

4. Fire below query.

select password, login from res_users where login='admin';

Hope this help for you.

Cheers,

Ankit H Gandhi.

Hello,

From V8/V9 the passwords are encrypted in the password_crypt field ... so you can check this field to see the encrypted password ...