Install PostgreSQL on Windows

Here we use EnterpriseDB to download and install, EnterpriseDB is the only vendor in the world that provides enterprise-level products and services based on PostgreSQL.

Download address:https://www.enterprisedb.com/downloads/postgres-postgresql-downloads.

Double-click the downloaded installation package to start installation

You can modify the installation path

Select the installation components, if you are not sure, select all:

Set the database path

Set the password for the superuser

Set the port number, you can use the default if it is convenient

Click Next directly

Click Next

Uncheck the selection and click Finish directly

Open pgAdmin 4

The pgAdmin homepage is as follows

Click Servers > Postgre SQL on the left 10

Enter the password and click OK

The control panel is as follows

Open SQL Shell (psql)