Shulou(Shulou.com)05/31 Report--

This article mainly shows you "how to install PostgreSQL under Windows", the content is easy to understand, clear, hope to help you solve doubts, the following let the editor lead you to study and learn "how to install PostgreSQL under Windows" this article.

download

After entering the official website, https://www.postgresql.org/download/windows/

Select Download the Installer

Choose to download the DB,OS version

Installation

After downloading, you see the exe installation file, which is only 159m in size.

Double-click to perform installation

Select installation path

Set the DB Super Admin password

Set the DB port. Default is 5432.

To set locale, the default is used here (this part of the concept needs to be further studied in the future)

Next step

Under installation

Finish, Stack bulider will be downloaded and installed

Next step,

Because server is not connected to the Internet, an error was reported. Cancel and exit Stack Builder.

Experience

Click the windows app to see that PostgreSQL DB and related software have been installed

Run pgAdmin4 (administrative tools like SQL server SMSS or Oracle Toad) to log in to DB

After logging in, you can see the web-based management tools presented in front of you, and there seems to be a lot of functions.

Click SQL shell (psql) in the windows application to enter the command line operation tool (should be similar to Oracle sqlplus)

The above is all the contents of the article "how to install PostgreSQL under Windows". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.