how to connect to database postgresql code example

Example 1: how to connect to remote postgres database from command line

psql -h  -p  -d  -U  -W

-W option will prompt for password

psql -h 192.168.1.50 -p 5432 -d testdb -U testuser -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