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
65
questions
3
votes
1
answer
16k
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 ...
- 10.1k
2
votes
1
answer
62
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
2
answers
4k
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 ...
- 339
0
votes
1
answer
514
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
1
answer
614
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?
1
vote
1
answer
2k
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 ...
- 339
1
vote
1
answer
100
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 ...
- 339
0
votes
1
answer
2k
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?
- 608
0
votes
0
answers
406
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 ...
- 147
2
votes
1
answer
2k
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 ...
- 505
2
votes
1
answer
4k
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
0
answers
408
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 ...
- 1,166
2
votes
1
answer
377
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,100
1
vote
2
answers
6k
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 ...
- 63
8
votes
1
answer
18k
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 ...
- 1,190