PostgreSQL Connecting to a Database

Internal

• PostgreSQL Operations

Connect

Connect to a database.

Options:

psql -h <host-name> -U <username> -d <database-name>

psql -h dev01.example..us-west-2.rds.amazonaws.com -U root -d dev01

Connect to the Default Database

psql -h localhost -U admin

Connect as a Specific User to a Database

psql -U <username> <dbname>