Answers for "connect to postgresql database"

SQL
1

psql connect

psql -d gpdatabase -h master_host -p 5432 -U gpadmin
Posted by: Guest on July-13-2021
0

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.
Posted by: Guest on February-18-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

Code answers related to "connect to postgresql database"

Code answers related to "SQL"

Browse Popular Code Answers by Language