Skip to main content

Questions tagged [pgadmin]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
26 views

Data source repair not working

Out of the blue, two table in my PostGIS are being flagged for multiple users as needing the data source repaired. The permissions, schema and database have not changed. Navigating to the table in the ...
I_suck_at_sql's user avatar
2 votes
1 answer
95 views

Exporting polygons to existing database in QGIS

I have exported a shp polygon file in QGIS to a table in pgAdmin. Now I have more polygons in QGIS that I want to export to the same table in pgAdmin. This means that I want to add the new polygons to ...
Alexi's user avatar
  • 71
2 votes
1 answer
118 views

intersect with ST_Buffer in PostGIS

I have a table called "gebaeude" with all types of buildings in the city. In the following I want to use a Buffer around the central train station that has the id="2" and a radius ...
Alm's user avatar
  • 83
1 vote
0 answers
130 views

Read only certain columns (read permissions) of a PostGIS database in QGIS

In our administration, each employee is given various rights to read and edit data on the PostgreSQL/PostGIS database. To view the geodata, we use QGIS. In this case there should be read permissions ...
cc_schr_gis's user avatar
2 votes
0 answers
206 views

Optimize spatial intersect PostGIS POLYGON table with large PostGIS POINT table (point-within-polygon test) [closed]

I have a very large table with a PostGIS POINT geometry column, about 1.7 Billion points. I want to query all points that fall within a number of 30 PostGIS polygons, stored in another table. Both ...
Alex's user avatar
  • 714
2 votes
1 answer
240 views

PostgreSQL Create A Line Column From Two Point Columns

My database has beginning and end points [beginning(x,y) ending(x,y)]. I want to create lines from this database for each beginning-end points. I tried ST_MAKELINE but this function wants location as ...
Bensu Gayret's user avatar
0 votes
0 answers
45 views

Displaying bit(1) data

I'm having an issue showing a type bit(1) data in QGIS. I can see the field in the DB Manager but once I load the layer in QGIS, the field disappears. Does it have anything to do with the default ...
Mr_Yum's user avatar
  • 1,134