login to postgres command prompt 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: connecting to a new database using postgresql sql shell
For Windows users using the SQL shell
\c DB_NAME USER_NAME HOST PORT
// to get the connection details such as your username, host and port simply use the "\conninfo" command
eg : \c test1 john_doe localhost 5432