Installing PostgreSQL on Windows
Here, we use EnterpriseDB for the download and installation, as EnterpriseDB is the only company globally that offers enterprise-level products and services based on PostgreSQL.
Download link: https://www.enterprisedb.com/downloads/postgres-postgresql-downloads.
Double-click the downloaded installation package to start the installation.
You can modify the installation path.
Select the components to install; if unsure, select all.
Set the database path.
Set the superuser password.
Set the port number; you can use the default.
Click Next.
Click Next.
Uncheck the options and click Finish.
Open pgAdmin 4.
The pgAdmin homepage appears.
Click on the left side: Servers > PostgreSQL 10.
Enter the password and click OK.
The control panel appears.
Open SQL Shell(psql).