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