The pgadmin3 tag has no wiki summary.
16
votes
5answers
2k views
Bulk load multiple shapefiles into PostGIS
I've got over a hundred data layers in shapefile format that I want to upload into a PostGIS database. They are all in the same projection, but represent different data layers so they do not have the ...
8
votes
4answers
5k views
How can I enable Shapefile GUI Loader in pgadmin3?
I have installed PostgreSQL 9.1 with PostGIS 1.5.3 on Ubuntu 11.10.
I also installed pgadmin3 1.14.0-beta1, following this instructions.
If I remember correctly, when I installed PostGIS on Windows ...
3
votes
1answer
110 views
How to import QGIS Raster into PostGIS
I have created a IDW heatmap using QGIS 1.8.0 and need to import the raster into PostGIS 2.0.1. QGIS saves the raster layer as a .asc file.
How do you import the raster into PostGIS as a Raster? What ...
3
votes
3answers
112 views
How to create feature dataset by pgAdmin(postgres) that can by use in sde conection?
How to create feature dateset in postgres(pgAdmin) that can by use in sde conection (arcgis)?
2
votes
1answer
113 views
Update query does not affect any rows, privileges are set to public and allow all actions
I've been trying to update a column of integers called level_dept in a table called adminboundaries within the sql query tool on pgadmin3 and the query runs and finishes with a lot of lag, but 0 rows ...
1
vote
1answer
42 views
why sql file generated by postgis was different in notepad and pgAdminIII?
When i imported a shapefile which contains some polygons into PostGIS by command line on Win 7, a problem puzzled me:
The sql file generated by shp2pgsql opened with notePad has the geom ...
1
vote
1answer
72 views
Creating admin roles with limited access to PostGIS
I'm trying to cram three different organisations into one server. Today they each have their own geoserver instance connected to separate PostGIS databases, which works fine. But now they also need to ...
1
vote
1answer
226 views
Is the PostGIS Shapefile Import Manager able to upload to phpmyadmin or only pgadmin III?
After trying to import a shapefile into pgadmin III with no success I was wondering how to successfully upload it, but also if it is possible to upload to phpmyadmin instead. In any case, how exactly ...
1
vote
0answers
113 views
How do I find the pgAdmin connection parameters?
I need to create a connection from arcmap to pgadmin using a python module because of an arcpy script, but I am unsure of how to get the pgadmin connection parameters. I think it may be some kind of ...
0
votes
1answer
181 views
GeoServer and local PostgreSQL database without Internet
simple question: can I work on GeoServer and local PostgreSQL database on my PC without need for Internet connection ?
would I be able to connect GeoServer to the database and create layers ? also ...
0
votes
1answer
101 views
Unable to load Shapefile using pgShapeloader / shp2pgsql-gui (pgAdmin3's PostGIS Shapefile Import/Export Tool)
I am trying to load a shapefile (http://dds.cr.usgs.gov/pub/data/nationalatlas/statesp020_nt00032.tar.gz) into PostGIS 2.0.1 using pgAdmin3's PostGIS Shapefile Import/Export Tool.
However its not ...
0
votes
0answers
42 views
Replace query not changing in pgadmin iii, but other queries working?
Upon adding a database to my postgres pgadmin iii server I attempted a replace query in the sql gui, and it worked. However I put in the wrong value to replace and whenever I try to do so again to fix ...
0
votes
1answer
183 views
Eclipse can't find Driver.class from postgresql-9.2-1002.jdbc4.jar file nor AbstractJdbc4Connection class
I am using the jar file in my configuration path after following the example from postgresql/jdbc tutorial. But after I added the jar file and configured it for my reference library when I run it I am ...
