Answers for "connect to database postgres"

5

how to connect to remote postgres database from command line

psql -h <IP_Address> -p <port_no> -d <database_name> -U <DB_username> -W

-W option will prompt for password

psql -h 192.168.1.50 -p 5432 -d testdb -U testuser -W
Posted by: Guest on September-25-2020
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

psql connect to another database

c DBNAME
connect DBNAME
Posted by: Guest on January-12-2021

Code answers related to "connect to database postgres"

Browse Popular Code Answers by Language