+2 votes
in Databases by (26.9k points)
After creating a new database, how to connect to it?

1 Answer

0 votes
by (45.8k points)

On the terminal of PostgreSQL, type the following command to connect to the database.

postgres=# \c database_name

Also, you can specify database name with psql command to connect to that database.

$psql -d database_name