Get lon/lat of feature in postgis

Question

I'm hava a problem I have a point layer (shapefile) insert to postgis! I'm using MapServer and OpenLayer to display layer on map! Now, i want get lon/lat all feature of layer! Hope somebody can help me! Thanks!

Answer 1

To extract lon/lat in text format from a database table, you can do something like:

SELECT ST_X(geom), ST_Y(geom) FROM yourgeospatialtable; 

Where geom is the spatially enabled column.

There probably is also an OpenLayers function to do that, but I am not exactly sure where you want to do it (server/client?)