postgres connect to database code example

Example 1: access the postgres psql

psql -h localhost -U username databasename

Example 2: postgresql connect to database command line

user@user-pc:~$ sudo -i -u postgres
postgres@user-pc:~$ psql
psql (9.3.5, server 9.3.6)
Type "help" for help.

Example 3: 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