PgAdmin: show the query results on a map

The geometry viewer of PgAdmin is already neat: by clicking on the eye icon, you can view the geometry of your geo-referenced rows.

So a query like this

select stop_name, geom from mtl_bus_stops;

would look like this

But wait, we can do better. By transforming your geometry in WGS 84 (SRID 4326), you can even display your results on a map directly inside PgAdmin

select stop_name, ST_TRANSFORM(geom, 4326) from mtl_bus_stops;

How cool is that 🙂