psql connect using username passowrd code example
Example 1: how to connect postgres user password using command line
sudo -u postgres psql postgres
Example 2: how to login using a particular user postrges
psql -d mydb -U myuser -W
psql -h myhost -d mydb -U myuser -W