The following steps are only meant for Windows Users.
How to connect the database server to Windows
- Click on the Windows start button and Navigate to PostgreSQL 13.
- From there, open the SQL shell and follow the steps demonstrated below to create a new database on Postgresql:
You can create the database with the name of your choice. In the above shell:
- \l is used to list all the databases created. You can easily see your newly created database at the bottom (testdb).
- \c connects you to your database "testbase".
And with that, your new database has been created!
Happy Learning! 😃