TransWikia.com

Shapefile loader in pgAdmin 4

Geographic Information Systems Asked on December 21, 2020

Recently I have updated my postgresql version. I have also upgraded pgAdmin from 3 to 4. But I was unable to load shapefile. I didn’t find any plugin called shapefile loader. How can I get the shapefile loader plugin in pgAdmin 4?

5 Answers

I also had to upload a shapefile to postgresql and found this solution perfect. Navigate to the given path

"C:Program FilesPostgreSQL9.6binpostgisgui"

Run the gui file "shp2pgsql-gui.exe"and a PostGIS Shapefile Import/Export Manager will appear. Here you can import shapefile from a specified path.

Correct answer by Shahzad Bacha on December 21, 2020

Another option (for MacOS) is to download the Opengeo Suite 4.8 from here http://mac.softpedia.com/get/Developer-Tools/OpenGeo-Suite.shtml.

Then only pull the PostGIS Utilities to your applications folder. You can then delete the pgAdminIII App and just use the pgShapeLoader. Works with pgAdmin4 too.
After that, follow instructions from this Boundless tutorial:
http://postgis.net/workshops/postgis-intro/loading_data.html

I don't know if or how this is working for Windows.
I am running postgres 10.4 with pgAdmin4 on MacOS 10.13.

Answered by blabbath on December 21, 2020

The other answers on this question so far doesn't cover the linux case. So, for linux users and in general for all other platforms, we can use QGIS to import shapefile to PostGIS or anyother spatial database.

Open QGIS, In top navigation bar, choose Database from the menu, select DB Manager.

Simply, connect to your database and choose import Layer/file option to import shapefile to database

option to connect to database and import shapefile

original answer can be found here

Answered by muzaffar on December 21, 2020

I use pg Admin 4 and I have got the shapefile DBF loader that works perfectly and I access it through the start menu. Whereas with pg Admin 3 it is under plugin on the GUI but not with pg admin 4. pg Admin 4 is not trash, it is perfect and works perfectly. I use both 3 and 4. Please ensure that you install the software correctly with all the necessary tools.

Answered by Amelia Nicodemus on December 21, 2020

I had the same problem and used the shp2pgsql-gui.exe that you can find at C:Program FilesPostgreSQL9.6binpostgisgui, it works fine.

Answered by Ricardo Pando on December 21, 2020

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP