Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange
The results are in! See what nearly 90,000 developers picked as their most loved, dreaded, and desired coding languages and more in the 2019 Developer Survey.

Questions tagged [pgadmin-4]

pgAdmin 4 is designed to meet the needs of both novice and experienced Postgres users alike, providing a powerful graphical interface that simplifies the creation, maintenance and use of database objects

0
votes
0answers
11 views

PostgreSQL pgAdmin4: Unable to view geometry in geometry viewer

On my windows 8 (x64) machine, I recently installed PostgreSQL 10.7 with pgAdmin version 4.5 using Enterprise DB interactive installer. My postgres db has a table my_table (geometry type: point). On, ...
1
vote
1answer
18 views

pgAdmin 4 load query from server [closed]

I installed pgAdmin 4.4. In the query tool I wanted to load a query that is saved on our server but this seems to be impossible because only the local drives c: d: etc. are provided. I tried to insert ...
1
vote
0answers
37 views

ERROR: function st_orientedenvelope(unknown) does not exist

I tried the example for ST_OrientedEnvelope given in PostGIS website but that failed. This function is failing for my table geometry column also. SELECT ST_AsText(ST_OrientedEnvelope('MULTIPOINT ((0 ...
1
vote
2answers
70 views

Load LINESTRING in WKT-format from CSV to pgAdmin?

I've got a CSV file with a column containing LINESTRINGs that looks something like this: 1,"LINESTRING(20.331 54.33, 21.67 44.89, 12.67 13.5679)",2014-03-09 13:30:33,2014-03-09 13:31:33 2,"LINESTRING(...
1
vote
1answer
62 views

PostgreSQL PostGIS: append table to another table [closed]

I have a large polygon table (30+million rows) and a smaller polygon table (45,000 rows). Both are PostGIS enabled. The smaller table only contains polygons that do not exist in the large table. Both ...
1
vote
1answer
53 views

PostgreSQL PostGIS: Spatial join but keep all features that don't intersect

Spatial joining a point table to a polygon table, creating a new output table. So far I can only get the output table to contain features that satisfy the spatial join. However, I want the output to ...
0
votes
2answers
259 views

ERROR: parse error - invalid geometry (Postgis)

Initially I was storing my column as path and then following this question I changed it to text. I'm trying to convert my column from text to geometry type by running this command: ALTER TABLE ...
1
vote
0answers
41 views

Import CSV to QGIS 3 where the geometry is in GeoJSON format

I have a CSV file with different attributes for each polygon. One of the attributes (column name) is GeoJSON which hold the geometry. For example, in the first polygon the geojson attribute is: {"...
1
vote
0answers
35 views

Setting PostgreSQL privileges for ArcGIS?

I'm migrating from SQL Server and setting up my first PostgreSQL server for use with ArcGIS. I've followed esri tutorials and related how-tos. I'll be using a versioned editing environment, as I ...
4
votes
1answer
700 views

How to solve “libintl-9.dll is missing” when trying to run PostGIS 2.0 Shapefile and DBF Loader Exporter

When I try to run PostGIS 2.0 Shapefile and DBF Loader Exporter I get the following error: The program can't start because libintl-9.dll is missing from your computer. Try reinstalling the ...
0
votes
1answer
2k views

How to upgrade pgAdmin 4 in Windows? [closed]

A new version of pgAdmin 4 is released almost every month. I wonder what is the correct way to upgrade a newer version of it? Is it necessary to uninstall the older version first and install the new ...
1
vote
1answer
30 views

Why does my source and target repeats itself when I use pgr_createtopology()?

I created my path in QGIS v2.18.18, making the lines and a combination of cleaning tool and explode lines tool to get my desired output. I tried using ROAD GRAPH plugin in order to check whether my ...
1
vote
2answers
304 views

PostgreSQL select value where '100%' using bigint

I am trying to select data from a bigint column in PgAdmin using SQL: SELECT FROM public.addressbaseplus WHERE uprn LIKE '100%' However, I am getting the following error: ERROR: operator does not ...
0
votes
1answer
55 views

ST_DISTANCE isn't giving the expected result

I don't get why ST_DISTANCE is giving me the same closest node when clearly it is not the one nearest to the starting point. Also, using 2 different starting points, I still have the same result. My ...
0
votes
1answer
67 views

How to find name of tables for which you are the owner in pgAdmin 4 [closed]

How to find name of tables for which you are the owner in pgAdmin 4?
0
votes
1answer
239 views

PostGIS update column with selected

I am new to database sorry if this is basic. I have selected point geometry from a geometry column in pgAdmin, however, I would like to know how to now copy the selected points to a new column? This ...
1
vote
1answer
61 views

Postgis pgAdmin ST_area returning different to other GIS's

I have a shapefile which is returning a different area value in pgAdmin than in FME, Cadcorp SIS and QGIS and I don't know why it is different in pgAdmin. The setting used in pgAdmin are: SELECT ...
0
votes
1answer
276 views

Create new database in shared drive Postgresql

I have my postgresql/ postgis installed in the c drive but I am running out of space. Is it possible to create a new database in the shared drive and access it from local pgadmin?
0
votes
0answers
127 views

Is Spatial clustering with PostGIS possible to generate N number of groups that have 10 elements?

I need to create a query using some sort of spatial clustering algorithm within PostGIS database. Currently, I am using pgAdmin version 4. More specifically, I need to create N number of groups that ...
1
vote
1answer
399 views

Problem with PostGis Shapefile Import/Export Manager with no explanation

I am trying to import a shapefile into PgAdmin4. I do it with PostGis Shapefile Import/Export Manager. I have a « connection failed » message with no explanation so I do no know where to search … My ...
2
votes
1answer
573 views

Is there a way to run a Python script inside pgAdmin 4 without relying on e.g. the QGIS Python console to do so?

I have a python script that contains within it an SQL command. When I execute this through QGIS Python console it also runs smoothly and returns the expected results without any problems. I would ...
0
votes
0answers
109 views

pgr_createTopology() 'Connection to the server has been lost'

When trying to create topology from pgAdmin 4 (version 2.1) with the pgr_createTopology function I get an error: "Connection to the server has been lost." The database is on localhost. The input ...
2
votes
1answer
130 views

i want to Search for points within a raster layer using ST_Contains. Keep getting no function matches given error

I have made a Simple points shapefile with seven points and I would like to be able to query which of these points are contained within the boundary of the raster layer. SELECT "points inside ...
1
vote
2answers
1k views

psycopg2 not working because column “geom” does not exist

I was planning to post this question on Stack Overflow before realizing that it probably was more related to my poor knowledge of GIS (I'm an absolute beginner in GIS and my knowledge of Python is ...
3
votes
1answer
3k views

Query field disabled in edit data mode in pgadmin 4 [closed]

I want to make a SELECT statement in the "View/Edit Data" mode in pgAdmin 4 but the query field is disabled. How can I enable it? (I have all privileges for all, the database, schema and table and I ...