pgAdmin4 now offers PostGIS geometry viewer

Give it a try:

1. Write a query that outputs a geometry or geography column. Below is an example.

   SELECT s.stusps, c.name, ST_Transform(c.the_geom,4326)
   FROM tiger.county AS c INNER JOIN tiger.state AS s ON c.statefp = s.statefp 
   WHERE s.stusps IN('CA');

2. In the data output, you should see an eye icon on the header column:

3. Click the eye icon and a new geometry viewer tab will open up. If you want to see a subset of your rows, select rows first.

   

4. Provided that your SRID is 4326, you'll see an optional layers selector.

5. If you have an SRID other than 4326, the map displays with no background. Following, I transformed my data to SRID 2163.

   SELECT s.stusps, c.name, ST_Transform(c.the_geom,2163)
   FROM tiger.county AS c INNER JOIN tiger.state AS s ON c.statefp = s.statefp 
   WHERE s.stusps IN('CA');

   

   If you click on a feature on the map, you can view the data in the non-geometry columns.