1
vote
0answers
36 views

Why do pgadmin III views show up as empty ArcSDE geodatabase tables in ArcCatalog? [on hold]

I have an SDE geodatabase connection set up in a server with data stored in a postgres database. I have successfully created views using pgadmin III but they show up as empty tables in ArcCatalog ...
1
vote
1answer
45 views

What date was a table loaded into PostGIS

Is it possible to find out the date a table was loaded into a PostGIS schema using PgAdmin3? The tables are usually supplied from varying external sources.
1
vote
3answers
159 views

postgresql export database with command or pgAdmin III

I want to export my postgresql db with pgadmin. I search all of its GUI, I also searched the web and I don't find some sueful information. I know how to import the db into postgresql: create a db with ...
1
vote
1answer
40 views

Error inserting GeoJSON in PostGIS

I know there is a similar question but I am getting a different error and none of those answers have helped. I am trying the following query (the GeoJSON itself is from the PostGIS website. INSERT ...
1
vote
1answer
43 views

Run PostGIS command line functions in pgAdmin?

Is it possible to utilize the PostGIS command line functions, e.g. shp2pgsql, from within pgAdmin III? I am using pgAdmin to connect to a remote server.
0
votes
1answer
34 views

managing postgresql database table using the pgadminIII sql tool

i have created a database using postgresql 9.1 and a table containing parcel information for a town council database on a windows 7 OS. i created the geometry column using the SELECT ...
1
vote
2answers
125 views

What is the best way to take a WKB value in SQL Server Management Studio and create a PostGIS geometry in PGAdmin III?

Normally, I would just use WKT strings but I'm investigating some possible geometry weirdness with the Text methods in SQL Server. I would like to copy/paste the WKB values from the SQL Server ...
4
votes
2answers
110 views

pgAdmin vs psql

I have downloaded postgreSQl 9.3 and Postgis 2.1 recently as an educational adventure and have been working with both through the pgAdminIII interface. I haven't used psql yet when working with my ...
0
votes
2answers
124 views

How to add other column into pgrouting query result in pgAdmin output pane?

I'm working on my final research project now and I'm a new user in pgrouting. Is there any chances to add another column name to display in the output pane? I'd like to add road name column so that I ...
5
votes
1answer
155 views

What spatially-aware GUI administration softwares exist for PostgreSQL/PostGIS (free or paid)?

Most of my experience with PostgreSQL has been PGAdminIII and psql, but I'm interested to know what others use. Is there PostgreSQL equivalent to SQL Server Management Studio (SSMS) and its ability ...
2
votes
0answers
19 views

Problem with postgres/quantum converting long/lat to suitable projection/SRID [duplicate]

I'm sure it's a simple question but this is all very new to me and after a lot of internet searching my points are still in the sea! I have a set of UK postcode data that I have converted into ...
2
votes
2answers
2k views

Install the Pgadmin3 shapefile importer plugin on a Mac(10.8)?

I'm new to GIS related things and I'm setting up a Postgre/Postgis database for geospatial queries. I'd like to import various shapefiles into the database and I found that Pgadmin3 has a shapefile ...
2
votes
1answer
953 views

How to restore a back up file into pgadmin III

My backup file containing about 50-60 tables , but I am able to just load only 6 tables for a new db and 31 tables for postgis dbase . And this was the error when I restore a backup file. pg_restore: ...
3
votes
1answer
1k 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 ...
0
votes
1answer
475 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 ...
2
votes
1answer
350 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 ...
3
votes
3answers
281 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)?
0
votes
1answer
377 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 ...
1
vote
0answers
338 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
338 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 ...
13
votes
6answers
11k 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 ...