I got a database with a column of type geography(Point,4326), the data contained looks like
0101000020E610000092E057F66EF73140930035B56CBD4840. How can I convert it to GPS coordinates?
It looks like this column is in Well Known Binary (WKB) or Extended Well Known Binary (EWKB) Format. You should try to query it using something like:
That will give you the textual representation. Not sure what you mean by GPS co-ordinates? Do you want to convert it into a
The alternative would be
which will give you the numeric lats and longs in two columns as your query table.
These are functions on Geometry columns --- on Geography columns, the following is correct:
The ST_X/ST_Y functions are only defined on the geometry type, so cast there before calling them.