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

1 Answer

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