How to display a PostGIS table on Google maps?

Question

I am attempting to take a shape file and display it on a map:

I can do something like this:

SELECT ST_AsText((ST_Dump(the_geom)).geom) as the_geom FROM shapes;

But the problem is I still have to do a lot of parsing of the data to get it to display on a google map. Is there a way to do this easily via google's javascript api?

Answer 1

GeoJSON seems to be a good way to deliver what your asking.

"This simple demo shows mountain backdrop preservation areas. We're using the showAll parameter since there are only a handful of features and there's no sense re-fetching features with each map pan or zoom."

http://geojason.info/google-vector-layers/demos/postgis-restful-web-service-framework/

Answer 2

There is also a simple option, http://postgis.net/docs/ST_AsKML.html