Installation and use of PostgreSQL under Windows

First, download

Select the version you want to download from Http://www.enterprisedb.com/products-services-training/pgdownload#windows, I am operating under the Win7 64 bit, The download is 9.4.4 version Http://get.enterprisedb.com/postgresql/postgresql-9.4.4-3-windows-x64.exe

Second, installation

Double-click Run, such as:

Select Next, such as:

Select the installation directory (I choose the default, or I can choose the installation path), select Next:

Select the Data directory (I choose the default, or I can choose the installation path), select Next:

To set the password for the Administrator account, select Next:

Select the boot port (default is 5432) and select Next:

Select the installation code, select C, and select Next:

Select next to start the installation

This step is completed, the extension tool can not be installed.

Third, the operation1. Find PostgreSQL in the program, such as:

You can use Pgadmin III's graphical interface or SQL Shell (Psql), which is recommended with the SQL Shell command line interface, run as follows:

The first is to select the server, the default is local, and other servers to enter the IP or host name, the second is the database name, the default is Postgres;

The third is the port, the default is 5432, the fourth is the user name, the default is Postgres, and then enter the password can be connected.

Then you can use it and quit using \q.

2. It can also be done with the Windows command line like Linux:

Press the shortcut key win+r to run CMD first:

Then run Psql:

Installation and use of PostgreSQL under Windows