title: View database user and password in PgAdmin
body: <p>How do I change a user's password in Postgresql (using PgAdmin) so that I can connect with Rails to the Postgres database using these credentials?</p>
  
  <p>So far: In PgAdmin I right clicked the database name, clicked Create Script and then typed the command: </p>
  
  <p><code>CREATE USER usr1 WITH PASSWORD 'pwd1!@#$';</code></p>
  
  <p>Question: where exactly in PgAdmin am I able to see the user and password or list of users and passwords? So far I am unable to see this in Db properties --> 'privileges'?? Any tips on other security elements? or something that can be improved in my current methods? Thanks a lot.</p>