login to postgres command line code example
Example 1: postgresql cli login
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
sudo -u postgres psql postgres
psql -d mydb -U myuser -W
psql -h myhost -d mydb -U myuser -W
sudo -u postgres psql postgres