[postgis-users] Highlighting features in PostGIS/PgAdmin

[Marcin Mionskowski]

What do you mean by highlighting features in PostGIS?
I don't know the pgAdmin. I use DBeaver. It displays objects on
OpenStreetMap and other backgrounds. If you execute statement like:
select id,geom,case when id=value then geom else null end geom2 from table;
then you will get all your geometries in blue, and those selected in second
column (geom2) in red. At least it works for me.
*Glory to Ukraine!*

wt., 1 mar 2022 o 12:34 Shaozhong SHI <shishaozhong at gmail.com> napisał(a):

> Since PgAdmin has very limited visualisation capability, work arounds are
> needed for highlighting features in PostGIS/PgAdmin.
>
> St_envelope can be used for putting a box around the features that need to
> highlighed.
>
> Any other functions that can be used for highlighting features in PostGIS?
>
> Regards,
>
> David
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20220301/7252ccec/attachment.html>