Installation Process:
In order to begin working with PostgreSQL we first have to install the management. We can do so by visiting the PostgreSQL download page: https://www.postgresql.org/download/ and then selecting the operating system that you are currently working with.
Once you have downloaded the setup tool follow the prompt to install the database management system. One of the sections in the setup process will ask you to enter the password for access to the database. Make sure to remember this password as it will be used when accessing the database through the client
when the installation is complete you will be prompted a confirmation screen from the setup tool:
After clicking you will be prompt with a stack builder which will allow you to install modules. From the list of applications select the Database Driver Npgsql and click next. Select the directory you wish to download the app and click next. This app will allow you to use the database with apps written in C#, Visual Basic and F#.
Optional Installation
If you like to work with a more visual interface to create and edit the database, there is a program that will do that similar to MySQL Workbench. That program is called pgAdmin and can be downloaded here:
https://www.pgadmin.org/download/pgadmin-4-windows/
After the installation, open pgAdmin and input the password set during the installation of PostgreSQL. Then after inputting the password you should have a screen that looks similar :
