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
3
questions
3
votes
1
answer
1k
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 ...
- 1,687
2
votes
2
answers
14k
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 ...
- 123
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