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.
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.
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 ...