How to connect to a database in PostgreSQL

+2 votes

asked Aug 14, 2019 in Databases by pythonuser (77.0k points)

After creating a new database, how to connect to it?

Please log in or register to add a comment.

+1 vote

answered Aug 14, 2019 by pkumar81 (354k points)
selected Jul 17, 2023 by pkumar81

Best answer

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