How to check password in Postgres-SQL command or query for particular User

Resolution

select user_login_id,user_password from aes_users where user_login_id='XXXXXX';