Answers for "connect db cli psql"

1

how to access postgres CLI

# User postgres is default. It then may ask you for password. 
psql -U postgres
Posted by: Guest on January-21-2021
1

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
Posted by: Guest on November-24-2020

Browse Popular Code Answers by Language