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

1 vote372 views1 answer
T-sql find object by name
SQL
0 vote359 views2 answers
How to add CHECK constraint to a column in postgres
SQL
3 votes331 views1 answer
Oracle user quota on tablespace
SQL
0 vote438 views1 answer
Delet all record statment sql
SQL
5 votes358 views2 answers
Postgresql add not null constraint
SQL
8 votes344 views1 answer
How to remove tables from postgresql
SQL
2 votes352 views1 answer
Postgresql update sequence next value
SQL
0 vote345 views1 answer
Sql get highest date from 3 tabels
SQL
2 votes328 views2 answers
How to get capital letter first in sql
SQL
0 vote351 views1 answer
Close sql query vb.net
SQL