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
0 votes
0 answers
35 views

Where "layer_styles" table is listed in the schema tree

Where can I find the "layer_style" table in the schema tree? I am using pgAdmin4, I have connected to the PostgreSQL database using QGIS and added the layer(s) that I want to style. Then ...
Hasan's user avatar
  • 55
0 votes
1 answer
63 views

Geographic Component in PgAdmin 4

I have a college project involving GIS, but I am new to this field. I have created a database using PgAdmin 4 and have added alphanumeric data to it. Now I want to add a geographic component to a ...
gisnoob's user avatar
2 votes
3 answers
93 views

QGIS will not save edits for data stored in PostGIS

So I am trying to edit data saved on a local instance of PostGIS within QGIS. However,whenever I try to save my edits I get the error message: I am capable of modifying the data how I want in QGIS, ...
Ian Moffit's user avatar
0 votes
1 answer
361 views

Error 2: Importing Shapefile to QGIS DB Manager Failure || PostGIS || PgAdmin

I am new to PostgreSQL, PostGIS, and pgAdmin. I am trying to import a shapefile through the DB Manager (PostGIS --> my specific database) in QGIS. I keep getting an Error 2 message indicating that ...
Alexia Hernandez's user avatar
2 votes
2 answers
68 views

Finding all isolated buffer points using PostGIS [closed]

I am doing a project where I find the banks in Ireland using PostGIS and pgAdmin I want to run a query that finds all the buffer spaces that do not intersect with any nearby buffers. I am using ...
Kwaiisan's user avatar
1 vote
1 answer
147 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, ...
Belurd's user avatar
  • 133
1 vote
0 answers
101 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, ...
kalaw23's user avatar
  • 139
2 votes
1 answer
930 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?
Lukáš Bílik's user avatar
1 vote
1 answer
7k 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 ...
brink's user avatar
  • 820
1 vote
1 answer
717 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 ...
raylight's user avatar
  • 1,221
3 votes
2 answers
3k 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 ...
Felix Chan's user avatar
5 votes
0 answers
282 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 ...
zakros's user avatar
  • 347
4 votes
1 answer
1k 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.
davidec00's user avatar
5 votes
4 answers
742 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?
PGeo's user avatar
  • 169
1 vote
0 answers
667 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 ...
Kurt Pelzer's user avatar
10 votes
1 answer
5k 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 ...
Kurt's user avatar
  • 7,065
1 vote
1 answer
227 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....
cymed's user avatar
  • 155
0 votes
0 answers
829 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 ...
Pawel's user avatar
  • 1
0 votes
0 answers
228 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 ...
Winni's user avatar
  • 1
0 votes
0 answers
444 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 ...
cymed's user avatar
  • 155
1 vote
1 answer
398 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 ...
Schoollife's user avatar
0 votes
1 answer
257 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 ...
Emanuelv's user avatar
1 vote
0 answers
86 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 ...
Asmita Guha's user avatar
1 vote
0 answers
230 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 ...
Paulo Martinho's user avatar
-2 votes
1 answer
786 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 ...
Ashish's user avatar
  • 29
2 votes
1 answer
517 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 ...
joe_gerner's user avatar
0 votes
0 answers
895 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 ...
ram_nl's user avatar
  • 159
1 vote
1 answer
2k 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 ...
mto23's user avatar
  • 623
1 vote
1 answer
149 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 ...
Huniya Sohail's user avatar
0 votes
0 answers
900 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 ...
GNG's user avatar
  • 421
2 votes
0 answers
912 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 ...
GNG's user avatar
  • 421
1 vote
0 answers
341 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 ...
Teo's user avatar
  • 11
1 vote
1 answer
208 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 ...
James B's user avatar
  • 2,139
2 votes
1 answer
434 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 ...
Michal De's user avatar
  • 205
1 vote
1 answer
844 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 ...
AJC's user avatar
  • 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 ...
Nic Pickers's user avatar
4 votes
2 answers
537 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 ...
DIV's user avatar
  • 886
1 vote
1 answer
1k 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 ...
DyndeMachine's user avatar
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 ...
Dev's user avatar
  • 11
1 vote
1 answer
684 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('...
Interested_Programmer's user avatar
1 vote
1 answer
416 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 ...
venkat's user avatar
  • 1,051
1 vote
0 answers
453 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 ...
Shana's user avatar
  • 628
3 votes
2 answers
2k 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(...
mrei's user avatar
  • 33
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 ...
Theo F's user avatar
  • 1,817
3 votes
1 answer
2k 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 ...
Theo F's user avatar
  • 1,817
2 votes
2 answers
16k 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 ...
Saim Mehmood's user avatar
1 vote
0 answers
362 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: {"...
user88484's user avatar
  • 1,769
1 vote
0 answers
233 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 ...
Barbarossa's user avatar
  • 5,797
13 votes
5 answers
13k 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 ...
TeddyTedTed's user avatar
  • 5,995
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 ...
Andre Silva's user avatar
  • 10.2k