The tag has no usage guidance.

learn more… | top users | synonyms (1)

0
votes
0answers
6 views

Problem with resotring to pgadmin from back up file

I appreciate any idea with restoring problem to pgadminIII from backup file. because I got the following error.
0
votes
2answers
47 views

How can I import a csv file with varying numbers of values per row into postgres?

I am trying to import a csv file into postgres using this statement: COPY T00_import FROM E'C:\\temp\\CSV\\Aberdeen City 9051_20150212_C_01.csv' CSV; The Table T00_import is a simple table with 17 ...
1
vote
0answers
39 views

How to install PostGIS shp2pgsql-gui on openSUSE 13.2?

I installed PostgreSQL 9.4.4 together with pgAdminIII (1.20.00) and the PostGIS extension (2.1.7, via the Stack Builder) from http://www.enterprisedb.com/products-services-training/pgdownload on my ...
0
votes
0answers
27 views

Changing postgresql security settings

I have setup a postgresql database with log ins as "admin" with full edits and "users" as read only. A number of "users" have been using this since for read only access. However, I set this up using ...
0
votes
1answer
122 views

How to bring my PostGIS map from GeoServer to Leaflet based web application?

I have created a group of shape-files using QGIS and I have stored their corresponding information in PostGIS database by importing the shape-file into pgAdmin3 using shape-file and DBF loader. Then I ...
0
votes
0answers
23 views

sql transformation from 29902(tm65) to 4326(wgs84)

ALTER TABLE Counties ALTER COLUMN geom TYPE geometry(Point,4326) USING ST_Transform(geom,4326); gives me the error: SQL error: ERROR: relation "counties" does not exist In statement: even ...
2
votes
0answers
48 views

Not able to get the PostGIS Layer Viewer running in pgAdmin or command line

I've installed PostGIS Layer Viewer as a plugin for pgAdmin. I've downloaded postgis_viewer.py from the official repository on GitHub! and followed the install instructions described on Web site!. ...
1
vote
0answers
113 views

Installing PostGIS Layer Viewer for pgAdmin III

I have difficulties installing pgAdmin's plugin PostGIS Layer Viewer. The official repository on GitHub gives this Web site for install procedure, then the former site gives this Web site for ...
0
votes
0answers
125 views

Changing http://localhost:8080/phpPgAdmin/ port number

I am trying to install geoserver using port 8080 and want to change the phpPgAdmin port number that is already in use. I am a basic user so detailed steps as to how to change the port (and what port ...
2
votes
0answers
120 views

How to get Geography data to GeoJSON in PostgreSQL?

I am using PostgreSQL database and there is a field in a table(area), i.e., public.geography(Points,4326). It contains below type of records "0101000020E6100000BA83D89942334540780B24287ED051C0" I ...
1
vote
0answers
62 views

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

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
70 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
5k 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 ...
3
votes
2answers
311 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
81 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
47 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
474 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
388 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
217 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 ...
8
votes
1answer
210 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
20 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 ...
1
vote
1answer
430 views

Loading PGadmin III GUI Linux

Having tested out the functionality of OpenGeo Suite Community, I have installed the Linux version on my Centos 5 Server. However unlike in windows the dashboard is greyed out for Post GIS. I believe ...
3
votes
3answers
4k 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
2k 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: ...
4
votes
1answer
2k 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
685 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 ...
1
vote
1answer
62 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 ...
2
votes
1answer
698 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 ...
2
votes
3answers
406 views

Creating feature dataset by pgAdmin (PostgreSQL) that can be useD in ArcSDE connection?

How to create feature dataset in PostgreSQL (pgAdmin) that can by use in ArcSDE conection (ArcGIS)?
0
votes
1answer
488 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
523 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 ...
1
vote
1answer
696 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
1answer
216 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 ...
0
votes
1answer
457 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
15k 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 ...
23
votes
4answers
4k 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 ...