+1 vote
in Databases by (8.7k points)
After creating a new database, how to connect to it?

1 Answer

0 votes
by (17k 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

...