Answered by : carlos-eduardo-sanchez-torres

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

Source : | Last Update : Tue, 20 Jul 21

Answered by : vikas-chauhan-venr7qwcfbt9

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

Source : https://www.prisma.io/dataguide/postgresql/connecting-to-postgresql-databases | Last Update : Thu, 12 Oct 23

Answered by : fantastic-ferret-mpsjogdjxt13

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

Source : | Last Update : Sun, 06 Feb 22

Answered by : lino-ngando

bash-4.2$ psql -h <hostname or ip address> -p <port number of remote machine> -d <database name which you want to connect> -U <username of the database server>

Source : https://www.enterprisedb.com/postgres-tutorials/connecting-postgresql-using-psql-and-pgadmin | Last Update : Mon, 18 Apr 22

Answered by : devbot-programmer

psql dbname postgres

Source : | Last Update : Fri, 29 Jul 22

Answered by : scary-salamander-f6i9t4dt7475

import sqlalchemy
engine = sqlalchemy.create_engine('postgresql://username:password@localhost/mydatabase')

Source : https://platform.codingnomads.co/learn/mod/page/view.php?id=1355&forceview=1 | Last Update : Thu, 10 Mar 22

Answered by : kinjal-suryavanshi

for connect to database write: \c databaseName

Source : | Last Update : Thu, 16 Dec 21