Postgresql connect to database

Psql connect

psql -d gpdatabase -h master_host -p 5432 -U gpadmin

Connect to database for postgresql

for connect to database write: \c databaseName

Postgresql connect to database

psql -d geo -h 192.168.1.12 -p 5432 -U supervisor

// geo is a database and supervisor is a user
// Once on postgres you can change the database by typing

\c postgres

Similar codes

0 vote143 views1 answer
How to query all tables mysql at the same time
SQL
0 vote143 views1 answer
Mysql beautifier terminla
SQL
0 vote150 views1 answer
Oracle sql number to varchar2
SQL
0 vote143 views1 answer
Mysql events not work
SQL
1 vote94 views1 answer
Alter user mysql native password
SQL
0 vote167 views1 answer
Get enginge db mysql
SQL
0 vote140 views1 answer
Function sum(text) does not exist postgres
SQL
0 vote163 views1 answer
How do I insert a blob in SQL?
SQL
1 vote145 views1 answer
Install postgresql on raspberry pi
SQL
8 votes127 views1 answer
Oracle add month
SQL