postgresql connect to database command line

patrick204nqh answered on February 18, 2021 Popularity 10/10 Helpfulness 5/10

answer postgresql connect to database command line

postgresql connect to database command line

Comment

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

Popularity 10/10 Helpfulness 5/10 Language sql

Source: w3resource.com

Tags: command-line connect database postgresql sql

Link to this answer
Share Copy Link

Contributed on Feb 18 2021

patrick204nqh

0 Answers Avg Quality 2/10

Closely Related Answers

connect postgres command line

Comment

psql -U <postgres> <Enter>
# enter password
# List databases:
\l
#change or select database
\c <dbname>
You are now connected to database "<dbname>" as user "postgres".
<dbname>=#

Popularity 10/10 Helpfulness 6/10 Language sql

Source: Grepper

Tags: command-line command-li

Link to this answer
Share Copy Link

Contributed on Aug 16 2023

@CodeGrepperManu

0 Answers Avg Quality 2/10

psql connect to database

Comment

psql -d postgres -h [host] -p [port] -U [user]

Popularity 10/10 Helpfulness 5/10 Language shell

Source: Grepper

Tags: connect

Link to this answer
Share Copy Link

Contributed on Jul 01 2022

Sore Seahorse

0 Answers Avg Quality 2/10

how to connect to postgres database using psql

Comment

psql -h <hostname> -p <port> -U <username> -d <database>

Popularity 10/10 Helpfulness 4/10 Language whatever

Source: www.prisma.io

Tags: connect

Link to this answer
Share Copy Link

Contributed on Oct 05 2023

Vikas Chauhan

0 Answers Avg Quality 2/10