[GIS] How to insert data into postgis database with phpPgAdmin

postgis

I have 50 line objects in .shp format in folder on my computer. I need to insert it to postgis database on the distant server.. When I log in in phpPgAdmin, it says it runs on localhost:5433. What is the quick way to insert my .shp data into database?

Best Answer

You can run shp2pgsql to convert the shapefile into SQL. You should be able to execute the resulting SQL file in phpPgAdmin.

QGIS offers a GUI for shp2pgsql via "Postgis Manager" plugin. You can connect to the remote database and load shapefiles directly without the need for phpPgAdmin.

Related Question