For importing or ingesting GIS shapefile to a postgresql database we can use shp2pgsql command, example: shp2pgsql -s 4326 -c -D -I myshapefile dbtable | \ psql -d dbname -h localhost -p 5432 -U dbuser In example above we convert or import the shapefile (myshapefile) to dbtable in dbname database with a dbuser. […]