How to get coordinates from geometry in PostGIS?

Question

This line: SELECT geom FROM myLayer.geom will return a hex value, i'm wondering how would it be possible to get decimal values, a result that look likes human-readable coordination?

Regards,

Answer 1

In addition to ST_AsText (which returns geometry as WKT / Well Known Text), there are several additional output formats, like ST_AsGeoJSON().

Take a look in http://postgis.org/documentation/manual-2.0/reference.html#Geometry_Outputs and choose, what fits your needs best.

Answer 2

use this:

SELECT ST_AsText(the_geom) 
       FROM myTable;

and viewing X,Y and geom object:

SELECT X(the_geom), Y(the_geom), ST_AsText(the_geom) 
       FROM myTable;

i hope it helps you...

Answer 3

SELECT * ST_AsText(the_geom) FROM table2;

Source: Beginner PostGIS question: getting geometry from multiple tables