How to import shapefile in PostGIS || PostgreSQL

In this tutorial, i will present how to import shapefile in PostGIS
PostgreSQL is a powerful, open source object-relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.
ESRI shapefile (SHP) is still the most common exchange format for sharing GIS data. The format itself is made of a few files such as SHP, SHX, DBF, and PRJ, where the first three are the required files and the file with projection information is not obligatory.

The standard PostGIS tool for loading shapefiles is shp2pgsql – you will find it in the bin folder of your postgres installation. shp2pgsql is a command-line utility that can either extract the shapefile data into SQL or pipe the output directly into psql (we’ll see both approaches). shp2pgsql also has a GUI version that can be accessed directly in PgAdmin.

#PostGIS
#postgresql
#PostgreSQL
#shapefile
#GIS
#gis
#webgisdevelopment
#shp2pgsql