Import ESRI shape file into Postgis

Download the install pack for your Windows platform from the PostgreSQL download site (http://www.postgresql.org/download/ ).

Launch exe to install PostgreSQL.

Once PostgreSQL is installed, launch Application Stack Builder from (Start->Programs->PostgreSQL 9.5->Applciation Stackbuilder

Choose the version of PostgreSQL you want to install PostGIS on and the version of PostGIS to install.



Navigate to spatial extensions and choose PostGIS 2.2., download and install. The PostGIS windows installer, does not create a template database. Use the CREATE EXTENSION postgis command for enabling PostGIS in a database. The create spatial database checkbox is optional, and we generally uncheck it. It creates a spatial database for you to experiment with and has all the extensions packaged with PostGIS Bundle pre-installed