View database user and password in PgAdmin
pgadmin, postgresql
Solution
In the file "pgpass.conf" in this path:
C:\Users\[User's name]\AppData\Roaming\postgresql
Problem
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? So far: In PgAdmin I right clicked the database name, clicked Create Script and then typed the command: `CREATE USER usr1 WITH PASSWORD 'pwd1!@#$';` 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.