Related

Create Database

psql

Create a new PostgreSQL database

Drop Database

psql

Delete a PostgreSQL database

Connect to MySQL

mysql

Connect to MySQL database

psql/connect

Connect to PostgreSQL

Connect to a PostgreSQL database using psql

connection
database

Command

psql -U username -d dbname

Explanation

Connects to the specified PostgreSQL database using the given username.

Examples

Connect as postgres user to mydb

psql -U postgres -d mydb

More

List Databases

psql

Show all PostgreSQL databases

Connect to PostgreSQL

postgresql

Connect to PostgreSQL database

Backup Database

psql

Create a backup of a PostgreSQL database