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

Filter by
Sorted by
Tagged with
1 vote
1 answer
15 views

Initialise variable with ST_Polygon

I use ST_Polygon in my queries: ST_Polygon('LINESTRING(-71.9436023 41.3108239, -71.7237582 41.0254994, -73.2015354 41.0545020, -71.9436023 41.3108239)'::geometry, ...
  • 133
1 vote
0 answers
25 views

PostGIS and QGIS - how to restrict delete, add, rename layer [closed]

How do I restrict users from deleting, adding, or renaming the layers from my database? or would it be possible to only show the project but not the layers? Note: I logged in to my superuser account, ...
  • 119
1 vote
1 answer
340 views

Geometry Viewer in pgAdmin 4 displays a straight line instead of polygons of European union countries

Via PostGIS I import a shapefile layer with polygons of EU countries. I try select all rows and after still display blue straight line without the end. Where is the problem?
1 vote
1 answer
2k views

Osm2pgsql error: authentication method 10 not supported

I'm getting the following error when trying to import osm data using osm2pgsql. I just installed pgAdmin4 today so it should all be up to date. osm2pgsql version 0.92.0 (64 bit id space) pgAdmin4 ...
  • 742
1 vote
1 answer
277 views

Forcing geometry columns to be small on pgAdmin 4

On pgAdmin 4, geometry columns always show as huge lines: So when I want to check the geometries inside Postgres I have to go all the way until the end of the line with a very small scroll bar: That ...
  • 1,081
1 vote
1 answer
672 views

Installing PostGIS extension with pgAdmin 4 on MacOS Monterey

I'm currently running into a problem on pgAdmin 4 where I am unable to use the PostGIS extension. I first tried running it this way through PGAdmin 4: DROP EXTENSION IF EXISTS postgis CASCADE; CREATE ...
5 votes
0 answers
164 views

Loading layer from PostGIS with non-unique primary key

I'm trying to load (by mean of PyQGIS) a layer from PostGIS based on query involving a inner join with a non-spatial table. When I run the query in pgAdmin I get the desired output but when I ...
  • 347
3 votes
1 answer
583 views

View two geometry columns together in pgAdmin Geometry Viewer

I have two geometry columns like this: How can I see them together in the Geometry Viewer? If i select all rows it shows only one column at a time.
5 votes
4 answers
387 views

Saving modifications in PostGIS layer edited in QGIS

I opened a PostGIS layer (from the server) with QGIS and I did some modifications (for example attribute join from another layer). How can I save my modifications so that it is visible in pgAdmin?
  • 169
0 votes
0 answers
372 views

SQL Server error when creating Geography data from a Multipolygon Geometry

So, in SQL server, I have a table called Municipios, which contains a column with 2463 entries of geometry type, with their SRID set to 4326. I'm running the following Query to try to convert them to ...
7 votes
1 answer
2k views

pgAdmin version 4-5.3 where is the geometry viewer

Updated the pgAdmin to latest version 4-5.3 on Windows 64 bit, I can not find the geometry-viewer anymore. So howto "activate" the geometry-viewer in the latest version? Update: As @JGH ...
  • 6,763
1 vote
1 answer
141 views

Interlis ili import into PostGIS

I am currently trying to generate an empty database in pgAdmin 4.29 using ili2pg. The Interlis model SIA405_ABWASSER_2015_LV95 is available here. The ili2pg-command I used is java -jar ili2pg-4.4.4....
  • 153
0 votes
0 answers
418 views

Layer is not valid error when connecting QGIS to PostGIS

I am new to QGIS. I am trying to connect a view from PostGIS to QGIS (3.16.4, same with 3.12). The PostGIS connection in QGIS browser have no issues and when "Test Connection" it says it can ...
  • 1
0 votes
0 answers
124 views

pg_tileserv SET DATABASE_URL return

I'm trying to set the SET DATABASE_URL for pg_tileserv in the cmd terminal using: DATABASE_URL=postgresql://postgres:[password]@127.0.0.1:60999/pgr which seems to be accepted. But when I start ...
  • 1
0 votes
0 answers
151 views

pgAdmin 4: create view without defining schema

I have a database containing the official cadastral surveying of hundreds of counties. For every county I have created a new schema named state_zipcode_countyname. As all my db entries have the same ...
  • 153
1 vote
1 answer
167 views

QGIS error message while running PostgreSQL code. WARNING Invalid PostgreSQL layer

I have run a code in pgAdmin it returns 43 rows of data. I took the same code ran it in QGIS and found the same row of data. However while trying to add the new data into the map QGIS comes with the ...
0 votes
1 answer
113 views

PostGIS: Can´t preview geometry when in different schema than public - why?

So I'm trying to wrap my head around PostGIS and how to get it working correctly in a schema other than 'public'. I followed this tutorial, and transfered PostGIS to my own schema, postgis_test. I ...
1 vote
0 answers
74 views

Making multi-layer mvt vector tile [closed]

I'm trying to make multi-layer vector tile using SQL query. I could able to make Mvt tile, but that was only for single layer. I got binary file from that query. How can I make multi-layer Mvt ...
1 vote
0 answers
180 views

Updating tables from QGIS to pgAdmin

I have created a connection between QGIS (ver. 3.10.1-A Coruña) and PostgreSQL (pgAdmin 4). Every time I edit/update my table in QGIS I have to delete the table in PostgreSQL and re-import again the ...
-2 votes
1 answer
509 views

Error when publishing a table/layer from PostGIS to GeoServer

The error messages pops up every time I try to publish a table from PostGIS in GeoServer. Oops, something went wrong... Sorry, something unexpected happened on the server. Here's an error report you ...
  • 29
2 votes
1 answer
413 views

Create PostgreSQL user for QGIS project

I have some data in a PostgreSQL database, I use pgAdmin4 for the organisation of the data. I want to create a QGIS project for other users with the data from my database. The users of the project ...
0 votes
0 answers
553 views

Connect QGIS to Remote PostgreSQL Server

I am trying to connect to my database on a remote server using QGIS. From what I've read I have to edit the pg_hba.conf and the postgresql.conf files. I think I have edited these files to allow any IP ...
  • 159
1 vote
1 answer
746 views

Error when creating PostGIS extension in pgAdmin4

I am trying to create a PostGIS extension in pgAdmin4. When typing CREATE EXTENSION postgis;, or through "db_name > Create > Extension > General > Name = postgis", I get this error: ERROR: could ...
  • 593
1 vote
1 answer
116 views

Query to Map GPS points with multi-linestring

I have a column of geometry of type multi-linestring in a database as in the following format Now I want to add a new column of speed by mapping GPS points against geometry column (as described ...
0 votes
0 answers
663 views

Downloading Census data to PostgreSQL PostGIS TIGER extension for Amazon RDS database

Can someone point me toward instructions on how to download census data for the postGIS_tigerP_geocoder extension? I would like to use the geocode() function, but any query returns 0 results. From ...
  • 413
2 votes
0 answers
684 views

Upgrade to PostGIS 3.0 in pgAdmin

I would like to use the new ST_TileEnvelope() function from PostGIS 3.0. My current version is 2.4.4. I would like to update to PostGIS 3.0 in pgAdmin. Is this possible? I have tried ALTER ...
  • 413
1 vote
0 answers
293 views

Access PostGIS on Heroku instance from GeoServer

In Heroku, I have a PostgreSQL DB with all the credential to be accessed by outside (Host, Port, Database name, User, Password, URI). Then I connected pgAdmin with this database using the above ...
  • 11
1 vote
1 answer
136 views

Transfer spatial data between databases using pgAdmin4

I'm new to pgAdmin4 and performing tests before jumping in the deep end. I've uploaded a large dataset into a the public schema within a database named 'spatial_db'. Rather than re-uploading the data ...
  • 2,109
2 votes
1 answer
350 views

pgr_createTopology uses too much memory and "connection to the server has been lost"

I have the large roads network (urban walking paths). I'm trying create topology in my database but when query reaches 175 thousands of edges, begins to increase memory usage. In the same time CPU ...
  • 195
1 vote
1 answer
655 views

Error while using ST_Line_Interpolate_Point: first argument isn't line

I've been running a scheduled task that contains some SQL code that has been running fine up until a few weeks ago. I don't believe any of the code had changed recently so I went through the debugger ...
  • 93
1 vote
0 answers
18 views

Setting constraint so that new value in "Table A" must already exist in "Table B", else return error? [closed]

I'm trying to set up some kind of constraint so that I can only enter values in "Table A", if that value exists in "Table B". I want this to act sort of like a selection list, where there are only a ...
4 votes
2 answers
364 views

Query in QGIS is significantly slower, than in pgAdmin

So, I've a table in postgresql, that is joined to other spatial table. If I've run a simple query in pgAdmin, let's say SELECT * FROM table1 WHERE "area" > '5000' and it takes less, than 1s to ...
  • 866
1 vote
1 answer
938 views

Restore backup from pgadmin 3 to 4 [closed]

Is there an easy way to restore databases from PGadmin 3 into Pgadmin 4? Right now data on both, and I want to gather all my data on the same server. The port on PGadmin 3 is 5432 and 5433 on PGadmin ...
1 vote
0 answers
2k views

Rendering 3D map in pgAdmin 4 to view Data? [closed]

I found this error 3D geometrics not rendered in view data (pgAdmin 4). In GeoDjango I've updated my PointField model with dim=3. After successful migration, I cannot see my data in map. My Django ...
  • 11
1 vote
1 answer
436 views

Parse Error on PostgreSQL when using ST_AsText

I am new to using POSTGIS and PostgreSQL. I am trying to convert PostGIS coordinates into lat and long values. When I copy one of the values and query like SELECT ST_AsText('...
1 vote
1 answer
269 views

Updating geometry as Multipolygon from Polygon table using PostGIS? [closed]

There are two tables in PostGIS. In which, one has polygon geometries with layer name wise and another one table has master layer name list. The requirement is to collect the polygon geometries as ...
  • 1,001
1 vote
0 answers
411 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 ...
  • 608
2 votes
2 answers
1k 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(...
  • 23
1 vote
1 answer
1k 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,517
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,517
1 vote
2 answers
13k 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
0 answers
291 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,597
1 vote
0 answers
180 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 ...
  • 5,747
12 votes
5 answers
11k views

"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 ...
  • 5,426
3 votes
1 answer
15k 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 ...
2 votes
1 answer
58 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 ...
  • 331
0 votes
1 answer
454 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
519 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
1k 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 ...
  • 331