4

I have two geometry columns like this:

enter image description here

How can I see them together in the Geometry Viewer?
If i select all rows it shows only one column at a time.

2
  • I don't think you can do that - try using QGIS
    – Ian Turton
    Commented Sep 20, 2021 at 10:36
  • 1
    You should check out dbeaver community edition. It's free and has a geometry viewer that allows you to select and view multiple geometries at once, like you're describing. It saves you the step of collecting or unioning the geometries.
    – jbalk
    Commented Sep 20, 2021 at 20:39

1 Answer 1

5

Not directly, but you can construct a new geometry - or a geometry collection - containing the two geometries using st_collect

select st_collect('point(1 1)'::geometry, 'linestring(0 0, 0 1)'::geometry)

or more likely from two tables

select st_collect(a.geom,b.geom)   
from a join b on ...

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.