Drawing results of PostGIS query?

Reading the solution to PostGIS > Intersect two circles. Each Circle must be built from Long/Lat degrees plus radius got me thinking.

How can I graphically display a SQL query?

It doesn't need to be cartographic quality. A sketch for debugging purposes would be sufficient.

For example, this SQL is in the accepted solution:

SELECT 
ST_Touches(temp.point1, temp.point2) as geom_touches
, ST_Intersects(temp.point1, temp.point2) as geom_intersect

FROM (


SELECT * FROM 
ST_Buffer(ST_Transform(ST_GeomFromText('POINT(-105.05083 39.74823)', 4326), 2877), 1500) as point1
, ST_Buffer(ST_Transform(ST_GeomFromText('POINT(-105.04428 39.74779)', 4326), 2877), 1500) as point2

 )as temp

How could I draw ST_Touches() and ST_Intersects() - the geometry, not the boolean?