log into postgresql on terminal code example
Example 1: how to login using a particular user postrges
psql -d mydb -U myuser -W
psql -h myhost -d mydb -U myuser -W
Example 2: how to connect postgres user password using command line
\password postgres